C
commassociates
I have two tables. Table 1 will be Orders and Table 2 will be
Customers. Here are the fields:
Customers:
Customer Name
Accout Number
etc.
Orders:
Order Number
Amount
Account Number
etc.
I will be importing data from excel with all the orders. What i want
to be able to do is when i import orders into the "Order" table, and
there is a new account number that is not in "Customers" table, i want
it to add a new record in the Customer's Table with that account
number. Is this possible?
Customers. Here are the fields:
Customers:
Customer Name
Accout Number
etc.
Orders:
Order Number
Amount
Account Number
etc.
I will be importing data from excel with all the orders. What i want
to be able to do is when i import orders into the "Order" table, and
there is a new account number that is not in "Customers" table, i want
it to add a new record in the Customer's Table with that account
number. Is this possible?