Kevin
I am assuming you want to associate all atty with a firm. That is one firm with many attys. The one relationship is the firm and the many are attys. You will need to approach it as follows:
Select atty
set order to firm_id
select firm
set relation to firm_id into atty
This will get the following:
Firm 1
atty a
atty b
atty c
When you navigate through the firm table you will be able to see all the attorneys associated with that firm.
Looking at the fact that you are using the atty table to drive the report makes me believe my assumpion may not be correct.
It has been a long time since I have used the relation command. I always create my table that drives the printing using SQL.
Gaylen
>Gaylen,
>
>Excellent, that did it.
>
>Is there something I'm missing with this code with XFRX?
>
>I'm trying to run a simple report that has a parent table (Atty) that's related to a child (Firm), and when I run it, I get the fields from the
>Atty table, but .F. from the Firm fields ...
>
>
>loSession = XFRX("XFRX#INIT")
>lnRetValue = loSession.SetParams("output.pdf",,,,,,"PDF")
>
>USE gcDataPath + [atty] IN 0
>USE gcDataPath + [firm] IN 0
>
>SET ORDER TO TAG Firm_id OF c:\foxdev\analyzer5x\data\firm.cdx IN Firm
>SET RELATION TO firm_id INTO Firm ADDITIVE
>
>SELECT atty
>GO top
>loSession.ProcessReport(gcProgPath + "reports\attylist.frx")
>
>
>
>Thanks for any help ...
>
>Kevin