Create record for each new record

[Robbin-R]

Hi,

I've created two related tables, that have a one-on-one relationship:

Now I would like that when I create a new record in tblProductions,
that automatically a new record with the same ID will be created in
tblPlanning.

Till now, this does not happen, and I guess it is because mostly none of
the fields of tblPlanning are filled in (except for ID, of course). However,
even if the fields are empty I would still like to have a record for every ID.

Regards,
Robbin
​

 

[Galaxiom]

Why have you separated the two tables?

 

[gemma-the-husky]

galaxiom is correct

if its a one to one record - then all the fields can be included in a single table

there are some circumstances in which a one-to-one relation is justified, but it complicates things - so it begs the question why you want to have 2 tables

 

[GaryPanic]

it could be to keep the tables smaller - I have a simliar problem that my tables are getting fatter - and it might of been best to split the information into 3- 4 smaller tables -


I have a compliance table and there is only ever 1 record to the main record but I have seperated it out as it is a seperate "class" but does relate to the product ...

you could alos have an admin table per record