Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
gunaro
Starting Member
2 Posts |
 Posted - 2009-01-14 : 14:18:33
|
hello, I am using Crystal Report and have the following problem in link tables. I have Tbl1 and Tbl2Tbl1 has to fields I want to link to the same field in tbl2. Example:Tbl1: ItemID, AccessoryItemIDTbl2: Item Description, QTY on Hand. The problem arrives due to the fact that tbl2 is the master item table which holds all item information. So I want to show for ItemID out of tbl1 just the description from Tbl2 and for AccessoryItemID from Tbl1 the Qty on hand from tbl2. I tried inner joints not enforced but no luck. Please help.Thanks |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2009-01-14 : 15:28:15
|
| Is there any fields that relates the table? |
 |
|
|
gunaro
Starting Member
2 Posts |
Posted - 2009-01-14 : 15:40:10
|
| Yes, both that's why I run into problems |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2009-01-14 : 17:59:37
|
quote:
Originally posted by gunaro
Yes, both that's why I run into problems
But I don't see. Which one? |
|
|
|
|
|
|
Link Table