I am using an API to send Customer and Address data to Dynamics.
I am storing customer data in the Contacts table, and Address Data in a separate, "Customer Addresses" (I know there's an address table, it isn't suitable)
I am need to display all customer information on the Model Driven App "Contacts" Form.
I have added an subgrid that displays the data from the Customer Addresses table. But it shows all addresses, not just those associated with that customer.
The customer addresses table has a relationship with the contacts table, and it seems to work properly with the Lookup column etc.
Maybe i'm approaching this the wrong way? Essentially, i need to display all of the associated addresses to that contact/customer, as if they were values from columns within the contacts table, but i can't see a way of doing this without using sub-grids. Sub-grids however seems to display all the values from that table, not just the ones associated with the contact that i am looking at that has rendered that form?
