On Saturday 05 January 2008 12:09:53 Eugénio Varejão wrote:
> 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
How have you defined your relationship between these two tables? If it is
defined correctly and both ID fields are auto increment, it should be
possible.
Dan
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
