I have created the junction box between two relationships that are many-to-many. I am having trouble creating the forms to write to the database. I get an error that states "Join Key of Table not in RecordSet". I have tried to use the Wizard to create the form and it will not work either. I have also tried using a query but no records are retrieved when I run it. Help!!!!!!!
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Many-to-Many Forms
- Thread starter BrentUSM
- Start date
Sorry I don't know how to do a link for a thread here. See if this helps. It was posted in the MS Access: General Discussion forum this week.
11/20/01 (posted 11/18) 8 responses
Many-toMany relationships - How to???
thread181-166130
Montrose Learn what you can and share what you know.
11/20/01 (posted 11/18) 8 responses
Many-toMany relationships - How to???
thread181-166130
Montrose Learn what you can and share what you know.
I'm using many-to-many in my database. You need to use a form for the main information and a subform for the information on the other side of the junction table. You can then insert the subform onto the form.
Linda Adams
Visit my web site for writing and Microsoft Word tips:
Linda Adams
Visit my web site for writing and Microsoft Word tips:
- Status
Similar threads
