Thanks - I think that'll fit the need.

Regarding the foreign key, it's not how I'd do it but I'm just playing the hand dealt while helping out.

I have an Orders table where several fields are setup as relationships to other tables, such as Customers and Warehouses. So, for instance, Orders.customer shows the customer's first & last name, which references Customers.full_ name.

I want to be able to select that customer's name for a particular record in the Orders table and jump directly to the referenced row in the Customers table. Currently, I'm copying the value, opening...