Multiple Joined Tables 关注
This is one of those probably really simple things that's just eluding me...we're new to BarTender and of course are under the gun to produce labels. I've attached a JPEG of our current join setup.
Trying to link to a single SQL Server DB and join 4 tables; OrderHeader, OrderLine, CustFile, CustShipTo
I can achieve the header and line join just fine - the trouble is when I get to the CustShipTo 2 tables away from my header information. I'm trying to achieve this:
Header -----> CustFile -----> CustShipTo
Header contains "ship to" code 3 for Customer A for example - I need to return "ship to" information for only Customer A, Code 3. I'm guessing I've messed up my join type for this. I'm hopeful I can simply use the Join Type dialog box without having to write custom SQL.
Right now...I select the proper header via query and I can get ALL #3 codes for all customers that have one - that isn't what I want.
If I'm not clear on my question - let me know - thanks!
★ BarTender Hero ★