Hi @PaulMugs
Let's say your have two tables, Table1 and Table2. These tables are in a one-to-many relationship and there is a foreign key in the Table2 that refers back to the primary key field or ID field of Table1, call it table1ID.
On the first screen, you will have a gallery, say Gallery1 with an Items property Table1. Inside the gallery, in the top row, place a ">" icon and set its OnSelect property to Navigate(Screen2,None,{personid:ThisItem.ID}). The element in the Navigate() function enclosed in curly braces creates a variable. in this case personid that will be carried to the second screen and identifies the record selected in Gallery1. In this case personid could be any name you want to choose and it is an alias for the ID of the chosen record.
On Screen2 you can have a ViewForm that has the same datasource as Gallery1 and the Item property would be Lookup(datasource,ID=personid). This can show all of the fields in Table1 for the record chosen in Gallery1.
Below the ViewForm place a datatable. The datatable should have its datasource Table2 filtered by the ID of the record chosen in Gallery1, the variable personid. To accomplish this, set the Items property of he datatable to Filter(Table2,table1ID=personid).
The datatable will show all of the records in Table2 that are related to the record chosen in Gallery1 and the fields in Table2 can be displayed..
