How to jump directly from one table to the linked (relationship) value in another tab

[newuser101]

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 the Customers table, and searching for the value, which is less than ideal.

Is this possible in Microsoft Access 2010 (datasheet view)?

[Rabbit]

You can use the where condition parameter of the OpenForm method to filter your form for that particular customer.

As a side note, you really shouldn't use the customer name as a key. It's not unique and it can change.

[newuser101]

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.