updating/adding to another table

[Marius Kaizerman]

Hi,

I'm working with access and sql server.
I have two tables.
Fields in table #1: barcode
(unique),transf er_to,quantity_ of_items,suppli er,price,date_o f_shipment
Fields in table #2: barcode (unique),transf er_to(unique),q uantity_of_item s
The first table is updated manually using a form, and the second should be
updated by the form itself
at the end of each record.
Note: in table #2, "barcode" and "transfer_t o" fields are unique.
At the end of entering a record in table #1, if "barcode" and "transfer_t o"
fields exists in table #2,
I want that the "quanity_of_ite ms" field in table #1 will be added to those
in table #2. But if "barcode" and "transfer_t o" does not exist in table #2,
I want that a record will be added with the same data
(barcode,transf er_to,quantity_ of_items).
How can this be done in access/sql ?

Thanks.

[MacDermott]

Whew!
That's a lot of cross-posting you're doing there!
It's usually considered appropriate to limit cross-posts to 2 or 3 groups.

As for your question -
is there some reason you need to keep table 2 data in a separate table?
It seems to me you could use a query (or view in SQL Server) to retrieve
this information from Table 1 on an "as needed" basis.

HTH
- Turtle

"Marius Kaizerman" <ma****@kaizerm an.org> wrote in message
news:ne******** ************@ln ews.actcom.co.i l...

Hi,

I'm working with access and sql server.
I have two tables.
Fields in table #1: barcode
(unique),transf er_to,quantity_ of_items,suppli er,price,date_o f_shipment
Fields in table #2: barcode (unique),transf er_to(unique),q uantity_of_item s
The first table is updated manually using a form, and the second should be
updated by the form itself
at the end of each record.
Note: in table #2, "barcode" and "transfer_t o" fields are unique.
At the end of entering a record in table #1, if "barcode" and "transfer_t o" fields exists in table #2,
I want that the "quanity_of_ite ms" field in table #1 will be added to those in table #2. But if "barcode" and "transfer_t o" does not exist in table #2, I want that a record will be added with the same data
(barcode,transf er_to,quantity_ of_items).
How can this be done in access/sql ?

Thanks.