Imagine this DB structure:
Products:
- Id
- Name
- CategoryId
Categories:
- Id
- Name
I can create two external content types for these tables. When these are created, I can start defining the associations. Adding a forward association is easy. This is the type of association that returns all products when a specific category is selected.
But that's not want I want to do. When you open the external list 'Products', you can see the id, name and category id of each product. But what if I want the category name shown instead of the category id ? Ideally, the category name would link to the specific category item in the external list 'Categories', but that's not a requirement.
Is this something that can be done with reverse associations ? From what I read, I understand this:
- A forward association (in this case) would list all products for a given category
- A reverse association (based on a stored procedure) would give the category for a given product
What I don't know is if this is useful in a view to show the category name instead of the id in the Products list. Or if there's any other way...
Regards,
Tom