Adding New Record with Table that has Duplicate Records

[aikiai]

My situation:

I have a table with duplicate ids. When I have a forum popup another form, the forms are linked by ids. This works great except for one problem. There are duplicate ids. So if I pop up a form then it will go to the first record that that id exist. This is not good if you are going to add another record. Therefore, I need to create a unique variable for a record. The autonumber would be a great variable but it seems I cannot use it to filter. Unless someone can show me how. Is there another way to create a unique variable automatically for a new record?

 

[ansentry]

post a zipped copy of your database.

 

[aikiai]

post a zipped copy of your database.

I wish I could but the information is medically confidential. Basically, I have autonumber variable called key set as my primary key. I have a form that has 2 tables connected to it. If I create an open button that opens another form then I would like to filter that index so the form will be at the right record. I can easily do this with a 1 table to 1 form setup but it seems the 2 tables to 1 form is causing a problem.

 

[ansentry]

1. Make a copy and take out the information and replace it with generic info.
then post it.

What is the relationship between your tables?

 

[aikiai]

I have created a quicky database that models my situation.

 

[ansentry]

I don't know what you want to use table2 for but it is now linked to table1 and the forms work.

My effort if very rough but it will give you an idea how to do it.

may I suggest that you have better names for you autonumber fields not just ID