How to create a new entry automatically in a related table ?

[philou]

HI,

I would like to know if it is possible to create automatically a new
entry i´n a table who is in relation one to one to another one. I
would like that a new entry be created in table B when I create a new
entry in table A.
Table A and B have some common fields which are link one to one.
I know I can fill table B when I am in table A by clicking on the +
and filling the other fields but I would like to find a faster way,
automatic way. Every entry in table A must have a correspondant entry
in table B.
I am using Microsoft Access 2003.

Thanks.

P.L.

[Tanis]

philou wrote:

HI,

I would like to know if it is possible to create automatically a new
entry i´n a table who is in relation one to one to another one. I
would like that a new entry be created in table B when I create a new
entry in table A.
Table A and B have some common fields which are link one to one.
I know I can fill table B when I am in table A by clicking on the +
and filling the other fields but I would like to find a faster way,
automatic way. Every entry in table A must have a correspondant entry
in table B.
I am using Microsoft Access 2003.

Thanks.

P.L.

I have to ask why you want to do this. It breas all the rules of
normalization. Ther should be no need to duplicate the data. IF you
really must do this, then I suggest using an append query.