Junction table question

[charlieb]

I am still new to access and db in general. My question is this: Is it better to create one junction table with many FK to join a bunch of tables where the tables themselves only need to relate to one other table or should I just build a junction table for each two tables that have a many to many relationship? the other question is, how many FKs can a junction table have?

[June7]

As many FK's as necessary to accomplish what you want.