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


__________________

Add a row with the image ID to the orders table

I don't know exactly what you want here. If you have a table which holds a list of unique records, which you use as "Valid" values to populate another table, I don't see any reason you'd want to insert a row into the "Images" table at all.

On the other hand, If the only purpose for the "Images" table is to provide a unique listing of the values which have been entered into the "Orders" table, then you simply don't need that table at all. You can get a distinct list of images directly from the "Orders" table by using "select distinct Image from Orders"

Of course, it sounds like you are using some kind of Access form to interact with your database and I don't know how much control you have over the way select statements are worded there.

Were would I put this line "select distinct Image from Orders" I am using access forms and do have limited options I think.

I have never used Access Forms, but a quick look tells me that you should create a "Query" using this sql statement, then attach it to your listbox using the listbox properties.

Thanks Ill give that a go....