Append Query works, but Table not showing records until db restarts

[mikerea90]

Hello all,

I have a form that is used as a sort of transaction window. Through this form I am able to connect records in a many-to-many relationship. I do this through a form and use an append query to make the relationship. The append query appends the primary keys of both tables as foreign keys to the link table.

The problem I am running into is that after I append the primary keys as foreign keys to the many-to-many relationship table, the appended records do not appear until I close my database and open it up again (I am looking at the link table after I run the append query). Does anyone have any suggestions as to how to fix this?

The foreign keys together are the primary key for the link table and referential integrity is not enforced on the link table - I was unable to enfore RI and also use the append query.

Thanks!

 

[HiTechCoach]

Are you requering the form after the append query?

Example:

Me.Requery

 

[mikerea90]

I just tried that and what happens now is that I will get the previous record in the link table that I did before. So if I just did transaction 929 and then 930. After doing 930, 929 will appear without me having to restart the db, but still no sign of 930...