I have followed the instructions on MSDN to "Display Related Data in a Windows Application" ( http://msdn.microsoft.com/en-us/library/57tx3hhe(VS.80).aspx ).
I have a data source that has a Customers table and a related Orders table.
I can easily create a form which allows the user to select a Customer and display the related Orders.
However, I cannot figure out how to create a form to select an Order and display the related Customer details (essentially the reverse of the MSDN example).
The relationship between the tables is Customers.CustomerID (PK) -> Orders.CustomerID (FK). Referential integrity is enforced (i.e. a Customer cannot be added to Orders table if they do not exist in the Customers table).
I must be missing something obvious. Can someone please point me in the right direction. Any advice is much appreciated.