[FX.php List] Related Records

[Bob Patin]

I retrieve the key for the relationship, and then do a 2nd query to  
show the related records. For example, if you're looking for a record  
with a key that equals 3, then I do my first query, find that record;  
then, on the same page, do a 2nd query searching in the related table  
for all records with that key.

It's a different way to do it from CDML days, where you'd use portal  
tags and show all related records that way...

Bob Patin
Longterm Solutions
bob at longtermsolutions.com
615-333-6858
http://www.longtermsolutions.com

   CONTACT US VIA SKYPE:
      USERNAME: longtermsolutions

   CONTACT US VIA INSTANT MESSAGING:
      AIM or iChat: longterm1954
      Yahoo: longterm_solutions
      MSN: bob at patin.com
      ICQ: 159333060


On Mar 20, 2006, at 10:08 AM, Tom Sepper wrote:

> Hello everyone,
>
> I've been lurking on this list for about six months now attempting  
> to grasp fx.php's functions and such.  Now that I've begun my  
> development, I have what is probably a very basic question..
>
> What is the best way to query for related records?  I know how I  
> want to display the records similar to a FileMaker portal, but  
> getting the data seems to be getting me!
>
> Thanks,
> Tom
> _______________________________________________
> FX.php_List mailing list
> FX.php_List at mail.iviking.org
> http://www.iviking.org/mailman/listinfo/fx.php_list

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://www.iviking.org/pipermail/fx.php_list/attachments/20060320/3759ac08/attachment.html