Joining tables with join fields from different tables

rbuser

Hi,

I have the following:

Table A: Client Code, Shift Date
Table B: Region,Client Code
Table C: Region,Date,Holiday?

Basically I need to check the date for a particular region and check if it
is a holiday. The problem is Table C needs to join to a field in Table A
and Table B to decipher. Is this possible using the standard end-user SQL
creation facility? (Using DBISAM as the DB)

Thanks

Alex

nicocizik

Hi Alex,

This can be done fairly easily using a Master - Detail - Lookup style setup.
If you run the EndUser demo located in the \RBuilder\Demos\3. EndUser\1.
Report Explorer\... directory and run the Customer/Orders + Lookup report in
the 02. DataView Linking folder you will see a good example of this.

--
Regards,

Nico Cizik
Digital Metaphors
http://www.digital-metaphors.com