You want to do a JOIN on the tables. When you add the second table to the report, you'll be able to link the two tables on the CustomerID.
>Hi there,
>
>I have never used Crystal reports and tomorrow I have to make a change to a report. What I need is to add a field on a report from a table that is not part of the report yet.
>
>
>Basically the report displays information about customer "A" and there's another table "B" that has multiple records about the customer (one to many) and I will get just one record from this secondary table and about 3 fields of that record need to go on the report.
>
>I think from reading stuff on the net that I can add the table to the report data list. Basically my next problem would be how do I do a filter on table "B" (it needs to return just one record), basically how do I pass the customer id and another field of the main table as parameters, I guess if I can get to that point when I drop a field from table "B" into the report it's already going to be filtered when I run it, right?
>
>Any suggestions?
>
>Thanks.
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer