[FX.php List] Getting a Related record ID

Malcolm Fitzgerald malcolm at notyourhomework.net
Sun Jan 15 23:42:00 MST 2012


Table "A" and table "B" have a one to one relationship. When I search on table "A" I would like to obtain the record ID from the related record in table "B". Is there a sneaky way to obtain the IDs or do I have to loop through my found set. 

What I would like to do is very similar to Filemaker's built-in Go to Related Records command. Having obtained a found set in one table I want to go to the related record set in another table. 

Malcolm


More information about the FX.php_List mailing list