[FX.php List] Getting a Related record ID

[Malcolm Fitzgerald]

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