Inserting data into multiple tables

I’m new to access and I’m trying to use one form to enter data into more then one table. For example I want to enter a record of a photo which is linked to a copyright, author and subject. If the copyright, author or subject doesn’t exist a new record needs to be entered in those tables.



Is there away to add all this data simultaneously or should I just be adding the extra fields to the photo table and kissing my data normalization goodbye? All the books/tutorials I have found only show adding records to one table at a time but I really does seem like this should be possible. Thanks for any advice.

Just use the same procedure you found for the one table and duplicate the process to your second table using basically the same syntax. If you are using a openrecordset of one table to add records, just create a second openrecordset of the other table and add records there..all at the same time.

lwells

Thanks for your response. But I think I’m going to need a bit more clarification. Here is a simple database that adds to two tables with one form except it doesn’t work. I need to update or know how to update it so it can and photos and a photographer if it doesn’t already exist. I hope this makes my question specific enough.


http://www.utteraccess.com/forums/download.php?Number=632797

Thanks

The link is broken that you posted. Please don't post links to other web sites. Just post the code that you are currently using and we can help you.

lwells