I have been migrating my data to CDS 2.0 and exploring Model Driven Apps. I have been able to bring in two related entities into a new MDA but have been unable to figure out how to create a view that shows the relationship between the two tables. The entities already contain a primary key and foreign keys.
For example, I would like to select a client (One side) and show the encounters (Many side). My data has Primary and Foreign keys in two entites but I can't figure out how to use them to create the view. Any help would be appreciated.
I appreciate the reference but I still can't figure out how to use relationships to help me display my data in a Model Driven App. I currently have a database of over 8000 patients with over 23000 visits. I have no problem relating them in a canvas app using Primary and Foreign keys but I can't seem to figure out how to select a single patient and show the visits using a model driven app. It seems like it should be simple but I am stuck on how to filter the visits entity after selecting a patient.