Script Help

[clsaulsberry]

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

[juraj_misina]

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

[clsaulsberry]

Thank you  that was helpful