Two tables looking at one

[runswithsizzors]

I have a report that has offices and clients and they both have shared keys to a table of addresses. When reporting how do I differentiate between which address goes to offices and clients.

It is just used on the report header.

This is all done in crystal reports.

Thanks

 

[runswithsizzors]

I just ended up creating two subreports, but was just wondering if there is away to do that.

 

[giadich]

Glad you got that sorted out but here's the answer anyway:

You should create a view which merges those those tables with the address table and add a new column in the view that indicates what kind of address it is.

 

[runswithsizzors]

Thanks for the reply I didn't even think of that. Maybe next time I will try that. Thanks again!