I have two different databases, A and B, that have identical key value fields. I have set up a form from a third, empty database that displays a text matrix displaying records from each database, A and B. When viewing information in this form, it would be nice if both database A and B were synchronized by their common key value field. Then when one record is selected in database A its associated record in database B would also be highlighted, and vice versa.
Being new to Panorama X, I am having a problem figuring out how to do this. So far, I have not found a useful function to use, and I have not found any mention of this type of linking in the Panorama documentation. Perhaps this requires a procedure that when triggered by one database will point to the correct record in the other database. What I am seeking is some hint of which direction to go, although I would not be surprised if I am overlooking something very elementary.