RDBMS in ms acces

Question

I have two tables:

1. Cartoon containing P_Name,U_Of_Pack,Weight,No_Cart,No_Pack,Tot_weight
2. Product containing P_Name,U_Of_Pack,Weight,No_Cart,No_Pack,Tot_weight

When any changes in the Product table are made to No_Cart, No_Pack, Tot_weight columns, these values should be subtracted from the same column's of Cartoon table & the updates should be applied in the Cartoon table (remaining column values).

Answer 1

MS Access does not support triggers on tables.

It would almost seem that Cartoon can be made up of a Query using Product instead of an actauls table. This will then still give you live results from the Product table.

If this is not the case, you would have to create an additinal query to update the Cartoon table each time you update the Product table.