Hello! I create a database for a list of products, the table with the products is called Base, and have the following fields: ID, Sub-Familia, Marca, Ref., Designação, Preço. Then I had created another table called Stock with the following fields: ID, Ref., QUANT, LOCAL and have a relationship between tables.
My idea was to relate the two tables and when I have a new product create the record in Base table and automatically create a new record with same ID and Ref. in table Stock, but this does not happen. When I need to create a new record in the table Base I need to create a new record in table Stock, and then update the other fields in this table. Can the automatic update of the table Stock be done? Regards, Eugénio Varejão
