I am using a microsoft access 2002 (10.6771.6845) SP3 program and recently linked new table to one I have been using a long time, with a one (new table) to many (old table) relationship, which worked fine when I created 22 forms linked to the original table and form.
However, I wanted to have the pirmary key numbers posted in both tables at the same time. So, I opened the original table's query, linked the two tables in it, and dragged the new table's ID number into the query.
Because an ID is required, I went into the old table and changed the "not required" to "required."
When I re-opened the original form, instead of getting the 1500 records usually found, I got only 22, which corresponded to the number previously entered in the new table.
I deleted the "required" condition I had put into the original table's ID, I deleted the new table's ID from the original table's query, and I deleted the link I had created between the original and the new tables.
Problems:
Instead of getting the 1500-plus records I used to have, I now have over 34,000, basically 15 copies or so of each original form. When I filter to work with a form, it reduces to one form which accepts all data just fine. None of the other forms I have developed based on the same table show this duplication, and the underlying table has only the original data, so everything else except this one form is fine.
The other problem is that to print this form yields only the heading, not the detail.
I tried database compact and repair, with no results.