SQL-Ledger Homepage

SQL-Ledger User Forum

Forum index page

Log in | Register

Back to the forum
Board view  Mix view

How is the shipto table related to the customer table (General)

posted by JayArr(R), Mission BC Canada, 17.05.2016, 15:47

Hi Greg

I don't know if you figured this out but here's what I came up with.

The Shipto table has a trans_id number that corresponds to the trans_id number in the ar table,

In the ar table there is a customer_id number that corresponds to id in the customer table and to trans_id in the address table giving you the customer and the mailing address.

Jeff





I have to write a quick query based on the ship to address, to find out who
the ultimate customer was. My problem is I am having trouble figuring out
how the shipto table relates to the customer table. ie: If I have a
child shipto record, how do I know who the parent record is?

Anyone have an idea how this is set up?

Gregory A. West

 

Complete thread:

Back to the forum
Board view  Mix view
976 Postings in 320 Threads, 326 registered users, 101 users online (0 registered, 101 guests)
SQL-Ledger User Forum | Admin contact
RSS-Feed
powered by my little forum