Many-to-Many Relationship Data Display in Forms

  • Thread starter Thread starter William W.
  • Start date Start date
W

William W.

I have a many-to-many relationship between Books and
Authors by ISBN and Author name. I.e. Books can have more
than one Author, and Authors can be tied to any number of
book ISBNs.

I am trying to use a text box to enter the auhtors names,
how do you seperate different authors and get the ISBN for
the current book into the Author's table ISBN field?

Or what is the best way to connect these two tables
correctly in forms and tables?
(I already have the JunctionTable)

Thanks
 
I am trying to use a text box to enter the auhtors names,
how do you seperate different authors and get the ISBN for
the current book into the Author's table ISBN field?

Or what is the best way to connect these two tables
correctly in forms and tables?
(I already have the JunctionTable)
Click to expand...

Use a Subform based on the Authorship table (which is, after all, the
Entity modeled by your junction table).

For instance you can have a Form based on the Books table, with a
Subform based on the junction table. The Master Link Field/Child Link
Field would be the ISBN; the subform would have a Combo Box for the
AuthorID, based on the Authors table.
 
Back
Top