Linking tables

[cis12232004]

I have a table that I am modifying. The table lists inventory item and number, the usage, unit cost and extended cost. What I now need to do is add the vendor table to incorporate vendor information for each inventory item. I linked to a vendor table based on inventory Id but when I tried to include the vendor information no data displays (the report is blank). I just did another linked table to another report and it worked fine. Is there something I am missing with this one?

Any help would be appreciated.

BTW, the last report had the vendor ID included already and I just had to add vendor name.

 

[cis12232004]

The table was created in Crystal 8.5 and I'm trying to access it with Solomon 5.5.

 

[Turkbear]

Hi,
It is probably due to there being some Inventory ID that does not have a matching entry in the vendor table..
To get around this, use a Left Outer Join between Inventory and Vendor.





To Paraphrase:"The Help you get is proportional to the Help you give.."

 

[cis12232004]

Thanks for your response TBear. I'm fairly new to this so could you give me a little help with the syntax for the left outer join (I'm using an SQL database).

 

[Turkbear]

Hi,
Use Database...Links window in Crystal Designer and click on the link from Inventory to Vendor..Choose Left-Outer as the link type.


I do not know the syntax for SqlServer or how to do it in Solomon.






To Paraphrase:"The Help you get is proportional to the Help you give.."

 

[cis12232004]

I tried the left outer join with the same result. The common field in both tables is the Inventory Description so that's what I'm linking on. In the linked table are the vendor name and ID and every time I attempt to add them to the report it just goes blank.

Any other suggestions??????????????

 

[Turkbear]

Hi,
It is possible the the Left-Outer is not working..What database exactly ( SQL is not a database, it is a language)?
Some databases do not support left-outer joins..





To Paraphrase:"The Help you get is proportional to the Help you give.."

 

[cis12232004]

I'm connecting using an ODBC. Does that help?

 

[Turkbear]

Hi,
Not really..What Database vendor - Is Solomon a database? Or does it Use SqlServer ( or Access or MSDE).





To Paraphrase:"The Help you get is proportional to the Help you give.."

 

[cis12232004]

It uses SQL