Linking tables (1 Viewer)

[wan2fly99]

have a report with ex: Invoice table (invoice_no, cust_no),
Address_table (cust_no)

Need to print invoices along with the customer address.


I put a link on Invoice table (cust_no) ---> Address table
(cust_no)


All I get is 1 row printing.


I take the link off and I get all the data.


I change the link to a lef outer join and it still does not work.


When I change the link: Address table (cust_no) ---> Invoice table
(cust_no)
get the data all invoices


I thought by putting a left outer join on the invoice tabke to the
address table I should get all the records in the invoice table and all
values in the address table that match the invoice table.


Now I am totally confussed

 

[boblarson]

If you right-click on the actual link you can get the options for that link to change the direction and other options.

 

[wan2fly99]

That is what I did to make the left outer join.

The main table is the Invoice table

So I should get all the invoice rows and any addresses that match up on the link Don't understand it

 

[wan2fly99]

Problem was that I did not have Cyrstal XI service pack#1 and #2 installed.

There was a bug with Crystal itself

 

[boblarson]

Glad to hear you got the problem sorted.