I'm stuck! This should be a common situation, but not straightforward. Tables would seem to be People, agencies, facilities, roles. Of course there's people's cell phones and emails, and agency and facility phones addresses and emails. An agency can have more than one facility. A person can be a director of more than one agency, a director of one and a supervisor of another of it's facilities, a director and a supervisor of all or some of it's facilities, or just a supervisor of a facility. So I have the table data I arranged in access from an Excel spreadsheet. I know I link the PK from agencies to a foreign key on facilities. But then what's the junction table or tables, and how do I get roles in there? And then, how do I populate and set up the queries or tables so I can see a person and the contact info and agency and facility their associated with, or an agency and the director, facilities and their supervisors? Thanks for the help!