I have 8 tables and each of them needs to have a many-to-many relationship with each of the 7 other tables. This would require that I make 28 junction tables and then deal with the mess that would be created on my relationships screen, which would make all the rest of what is being represented on the screen that much more difficult to understand.
So I was thinking I could just make one junction table containing foreign keys for all of those 8 tables. Then to use any of the relationships in a form I can create a query that selects only the two foreign keys I want used in the form.
Is this something that can work, or will it lead to problems?