D
D Hafer - TFE
I have a local database which imports orders from a SQL table from an on-line
shopping cart.
When I do the append query, I need add an identifier to indicate on my local
orders table that the appended record came from the on-line shopping cart.
I'm going to be updating this order table with local, point of sale
transactions.
I'm planning on creating a unique key between Row ID & this text identifier
(let's call the field "Type"). So, the unique key for the order table will
be a combination of ROW ID & Type. Online transations would be Row ID 1 +
Type = "Web". For point of sales transactions, the unique key would be Row
ID 1 + Type ="Store".
When I'm doing the Append query to update the orders table on the local db
from the online tables, how do I add the column to to add the text "Web" into
a the type column on the orders table as my source tables to not have this
identifying column?
Do I have to run an immediate "Update" query or can I just have some SQL in
the append query to perform this action?
shopping cart.
When I do the append query, I need add an identifier to indicate on my local
orders table that the appended record came from the on-line shopping cart.
I'm going to be updating this order table with local, point of sale
transactions.
I'm planning on creating a unique key between Row ID & this text identifier
(let's call the field "Type"). So, the unique key for the order table will
be a combination of ROW ID & Type. Online transations would be Row ID 1 +
Type = "Web". For point of sales transactions, the unique key would be Row
ID 1 + Type ="Store".
When I'm doing the Append query to update the orders table on the local db
from the online tables, how do I add the column to to add the text "Web" into
a the type column on the orders table as my source tables to not have this
identifying column?
Do I have to run an immediate "Update" query or can I just have some SQL in
the append query to perform this action?