
Crystal Reports - Fields from linked Access Tables ??
Seaking help with
Crystal Reports...
I have something like the following:
Access table: ADDRESS
Address-Id
Address-Line1
...
Access table: JOBS
Job-Id
Bill-Addr-Id
Deliv-Addr-Id
IE The table ADDRESS is linked to jobs via two fields, Bill&Deliv-Addr-Id
I have setup the links required within CR. (Infact is automatically took
them from the 'relationships' I defined within Access.
The question is if I wish to display a job, and the related Billing AND
Delivery address on one form, how do I do it.
The insert-database-field shows both the Address and Jobs table, but when
selecting Address-Line1, how do I indicate I want the one read via the
Bill-Addr-Id link.
Many thanks