Results 1 to 2 of 2
  1. #1
    5 Star Lounger
    Join Date
    Jan 2001
    Location
    Ephrata, Washington, USA
    Posts
    683
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Relationships - entering data (Access 97 SR2)

    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?

  2. #2
    5 Star Lounger
    Join Date
    Jan 2001
    Location
    Ephrata, Washington, USA
    Posts
    683
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Relationships - entering data (Access 97 SR2)

    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!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •