Easy Question about Many to Many

[hoodoo]

Because a book can have multiple authors and an author can have multiple books. This is a many-to-many relationship and requires a junction table.



Maybe tblAuthorsEditors should be tblPeople, then you could also have the quote authors in that table.

But which fields should I choose as lookup fields in main table then? AuthorEditorID? Isn't it possible to make it so, that you can choose author and editor from lookup fields in the main table?

[orange]

see this for more on many to many

Many people will tell you never use lookups at the table field level. because

[June7]

If by main table you mean tblAuthorsEditors, yes AuthorEditorID would be the lookup field (on a form this would be a combobox control).

As orange points out, experienced developers avoid lookups in table design. However, since you are restricted from using forms, you don't really have option.