Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Can you help me connect these tables correctly with a script?
I have 5 Tables, I need the to keep all of the information on table 1 and if the other tables have table 1 information for the other columns in the tables I need to pull that information.
Table 1
order Number
Carton Number
Sku
Table 2
Order Header Key
Order number
Sku
Return number
Order Amount
Order Date
Table 3
Order Header Key
Order number
Sku
Appt Date
Table 4
WO Key
Order number
Sku
WO number
WO Status
Table 5
WO key
Note Text
Contact User
Have a look at Exists() function here
Table 1 order Number Carton Number Sku Table 2 Order Header Key Order number Sku Return number Order Amount Order Date Where Exists ([Order Number]) Table 3 Order Header Key Order number Sku Appt Date Where Exists ([Order Number]) Table 4 WO Key Order number Sku WO number WO Status Where Exists ([Order Number]) Table 5 WO key Note Text Contact User Where Exists([WO key])
Hope this helps.
Juraj
Thank you that was helpful