I have come across blogs about how to setup an external content type. For example:
But I have not seen any examples of what to do when your external SQL DB has foreign keys.
For example. I have a database that has orders and customers. An order has one and only one customer and a customer can have many orders.
How can I setup external content types in such a way that when in the list view of these external content types, I can jump between and possible lookup values to that other type?