connecting a selected row in 2 portals
I 'm quite new to this and can't seem to find a way through this.
I have a database with a parent table containing fields for a client (id, name, address, etc) and a child table containing fields such as appointment date, medication list, exam findings, etc. These two tables are linked via a foreign key in a 1-to-many relationship, since each client can have many appointments, and each appointment corresponds to a single medication regimen, a single clinical exam, etc.
In the layout, I have created the 1st portal containing only the appointment dates. In a tab, I have placed the exam findings, using a 2nd portal, sorted according to the appointment date. What I 'd like to do, is click on a specific date on the 1st portal (or a button inside there) and then have the other portal containing the exam data focus (move) to the corresponding results for that selected date.
So far, I have only managed to see new appointment dates created on the 1st portal when i type in a new exam row in the second portal, but that's about it.
any help is appreciated