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!