Crystal Reports - Fields from linked Access Tables ?? 
Author Message
 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




Sun, 09 Aug 1998 03:00:00 GMT  
 
 [ 1 post ] 

 Relevant Pages 

1. Crystal Report cannot see new field that is added to MS Access table

2. Help!!! Crystal Reports, Access table with OLE fields

3. 4.6.1.0 32bit Crystal Reports error reporting links in 3 table database

4. Formula field to table field name (Crystal Reports 8)

5. Linking Crystal Report with a stored Procedure -- crystal report for visual studio.net

6. HELP: table links in Crystal Reports Pro 4.6.1

7. HELP: Crystal Reports table links

8. Crystal Reports Linking Tables

9. Crystal Reports Table Links

10. HELP: table links in Crystal Reports Pro 4.6.1

11. HELP: Crystal Reports table links

12. Help Please !!! crystal report table cannot linked

 

 
Powered by phpBB® Forum Software