can I have multiple links to one table? 1

[maggielady]

I have two tables, family and lookup, if I have one link established between the two, the family status(from family table) to table id (in the lookup table) I called this family status. And I dropped the table description field right on the report and it worked great. Now I need to make another connection between the family db and lookup db. Now I have a user defined field that holds a number that relates back to the lookup table in the table id field. And I need to get the same field( table description) on my report somewhere else if the family udf # matches the lookup table id. If I make another link from family db (udf) to the lookup db(table id) and if I use both in a report it wipes out all my info on the report. I tried to link both the family status and udf field to the lookup table id and that's when I get nothing. If I use one link and use the table description field once in the report it works fine. I'm confused. Thanks for any help in advance. Hope I explained this well enough

 

[IdoMillet]

Add the lookup table a second time to your report (Using Database, Add Database to the Report). You will be prompted to give this new instance of table an alias.
Then join from the 2nd column to this alias.

Cheers,
- Ido


CUT, Visual CUT, and DataLink Viewer:
view, e-mail, export, burst, distribute, and schedule Crystal Reports.

http://www.MilletSoftware.com