linking 2 access tables

[malka]

Crystal Report 8.5. Access 2000.
I have 2 tables in Access, that I need to link. visual linkingd links between the keys.
Customer table key on - Customer ID.
Company table key on - Company ID.
I would like to link Company IDs in both tables.
How do I force it to link this way.
Thanks,
Malka

 

[AndrewBaines]

In the visual linking expert, clear the existing links and drag and drop to link properly.
Crystal 8 and later has the additional facility to link according to the database definition instead of just the field names. I'm sure it works with Access, you'll just need to define the links in Access then tell Crystal to link by key instead of by name. Andrew Baines
Chase International

http://www.chase-international.com

 

[malka]

Andrew,
Thanks.
Malka