[FX.php List] Getting a Related record ID

[BEVERLY VOTH]

Malcolm, since you have a record, why not search for related using the key/match field(s)? I use this all the time. If you have a "filter" on the portal, you can even include that in your find for related records. I don't use the -recid, as that's not what's used to "match".

Beverl

On 16 Jan 2012, at 1:42 AM, Malcolm Fitzgerald wrote:

> 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_______________________________________________
> FX.php_List mailing list
> FX.php_List at mail.iviking.org
> http://www.iviking.org/mailman/listinfo/fx.php_list