Crystal Report, Values from Multiple tables

See more:

C#

C#4.0

CrystalReports

Hi,

i am facing problem in crystal reports...

The situation is "Need to generate a report that fetch values from different tables from MS ACCESS".
Each tables have one field in common... (eg. CNUM-fieldname)
CNUM also Unique in each table...

eg. CNUM in tab1, tab2, tab3.
if the CNUM value is 1002 means i need the rows from all the 3 tables one by one where CNUM=1002....

like,
tab1 - field 1, field 2,...
tab2 - field 1, field 2,...
tab3 - field 1, field 2,...

if the CNUM is not in any of the table the field values should be blank spaces
like,
tab1 - field 1, field 2,...
tab2 - , ,...
tab3 - field 1, field 2,...

can any one give me a suggestion to solve this please.....