The add page will add a record to the Setup table. When selecting a Part Number to add to the setup in the drop down box, I would like to also display the customer that Part Number belongs to. Currently, I have only figured out how to display the CustomerKey found in the Part table and am unable to link to the Customer table to display the CustomerName.
I have the same problem. Even after adding $expand field with correct table name, I am not able to see the fields of the expansion table. Related Information: Add Basic Filter page (For basic filter table), which has Attribute_ID as FK to Attribute table. Attribute table has Topic_ID as FK to Topic table.
When clicked on the Columns of the "Attribute", the following page comes up when I click on the Property dropdown, the list appears only with the fields of Attribute table, there is no Topic field in the list.
There are several things you can try, but I do not have enough information to determine what exactly you need to do.
Ensure you have included the expand parameter on all required load events, such as the Page or Form load event.
If the expanded table is more than one table removed from the source table, you need to modify the statement slightly. Please reference my ERD at the beginning of the post. When expanding to the Customer table from the Setup table, my expand parameter will read: Part,Part($expand=Customer). You must first expand to the Part table before expanding to the Customer, but I do not know your model so I cannot say for sure.
You may also try just typing the property you wish to select manually, even if it is not included in the dropdown list. So if you want the topic, simply type 'Topic' in the property and select add. If topic is in an expanded table you will have to type Topic.TopicName or whatever you have named your table and attribute.
Hopefully this helps, if not you could try including some more information.