Many-to-Many Relationship Data Display in Forms

[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

 

[John Vinson]

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)

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.