Insert record in one table and it inserts a record in another

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

mwdmanjg - 05 Jan 2005 18:51 GMT

I have a main form that when i create a record in it i need it to create a
record in another form that will include the first records key value in the
second forms key value field. help please, thanks in advance

Reply to this Message

John Vinson - 05 Jan 2005 20:49 GMT

>I have a main form that when i create a record in it i need it to create a
>record in another form that will include the first records key value in the
>second forms key value field. help please, thanks in advance

This is NEVER either necessary nor is it a good idea. Creating such
empty "placeholder" records does you no good at all!

Instead, make the second form a Subform of the first one, using the ID
as the master/child link field. Then when you actually enter data onto
the subform, the ID will fill in for you automatically (but not until
you need it).

John W. Vinson[MVP]

Reply to this Message