Add Macros??

[Keith]

I have set up a db for a client that is used for Invoices,
Customer Data, Layaway Payment's, and Inventory.

At this time the inventory is set up so that each item
must be put in one at a time with the Item serial number
as the key ID. This is too time consuming for the client.

I would like to set it up so that the user could add
inventory in the following way: in a temp table type in
the Item Name, Item category, and number of Items. Then
can I run a query that would check the inventory table and
if a matching Item Name, Item category is found then it
would add the number of item to the inventory table. If no
match is found the Item Name, Item category, and number of
Items would be added.?

Any help would be great.

Keith