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

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

Post by bXdkbWFuam » Fri, 07 Jan 2005 03:51:12


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
 
 
 

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

Post by John Vinso » Fri, 07 Jan 2005 05:49:22

On Wed, 5 Jan 2005 10:51:12 -0800, "mwdmanjg"



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]