Add data to two tables.......

Hello all you nice folks out there in the nether regions of cyberspace.

I have a issue in access that I could use help with.

I am creating a database that is proving a little tricky...
I have tables that list names if 'images' and 'museums'. this is all that is in these tables so that i can run a query that will list the names without duplicates showing in my 'orders' table/form.

The problem lies in I need to be able to have duplicates under the "images" colum in the 'orders' table but I do not want duplicates showing in the 'images' table. I also need to be able to add images to the list when i input them into the 'orders' form.

So how do i input from a form into two different tables, were one table holds no duplicates but the other allows duplicates?

Hope you can answer this for me thanks.

Jediwizzo

This sounds like the orders/images references the images table.

If the image does not exists in images, they shouldn't be able to order it right? I'm just trying to think of why you would need to have it insert into 2 at the same time.

My theory is if you have a new image to offer, you upload it and add it to the image database, and then users surf that database and say, i want that one, in which case you're not doing 2 inserts at the same time.

Am I understanding correctly?

The problem is we service museums in B2B products for their retail shops. So the image database grows almost as fast as I can type the orders. The problem is mainly that I am creating this database from scratch so I want to avoid entering all the data into more than one place even though I need it in both tables.

So far the easiest thing I have come up with is making a append query that I can run and this will add all the new entries from the orders table into where I need them in the single tables.

I guess I will jsut use a macro that when I close the orders form it then runs the append queries. This seems like my only real convienient fix to this.