AnsweredAssumed Answered

connecting a selected row in 2 portals

Question asked by grouper on Apr 29, 2014
Latest reply on Apr 30, 2014 by philmodjunk


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