Need Some Expert Advice

[BruceFrey]

Hello

I'm looking for a general answer on a situation I'm having with an inventory database. I'd like to ship multiple items at the same time by adding records to a transaction table based on a criteria match from the item number table. An update query only updates existing records.

Because I'd be adding multiple ship transacations into a table I'm unsure how to proceed. Any suggestions would be very much appreciated.

Regards

 

[pbaldy]

Sounds like you want an append query instead of an update query:

INSERT INTO...

Holyoke is near Springfield, isn't it? I spent a year or so with my uncle in Agawam many years ago, and I seem to remember Holyoke being nearby.

 

[Atomic Shrimp]

For transactions containing multiple item lines, you might want to consider storing the transaction data in two tables - one for the header information (customerID, TransactionID, delivery address, etc) and another for the item detail lines (Transaction ID as a foreign key, itemID, Qty, price(if not determined by a fixed formula), etc.)