Relationships – entering data (Access 97 SR2)

Topic

New Reply

Dumb question, here. But, I have a junction table that contains the foreign keys to several other tables. I have set the relationships as one on the foreign key tables and many on the junction table. The junction table only contains the foreign keys and its own primary key.
Question: When I enter data in the foreign tables via a form, the related FKs are not showing up in the junction table. It doesn’t update at all in fact, but the data shows in the foreign key tables. How do I get the data into the junction table?

Reply | Quote

Replies

Nevermine. I figured it out. I just deleted my existing form and re-created it with the form wizard. Works beautifully! I had been dinking around in design mode and had somehow messed it up. Sometimes ya just gotta cut your losses and start over!

Reply | Quote