By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,717 Members | 1,268 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,717 IT Pros & Developers. It's quick & easy.

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

P: n/a
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.
Nov 13 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a

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.

Nov 13 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.