A bit of a beginner to all this database stuff, but I'm learning...
I am trying to write an Access query getting data from three tables:
- FileNumber(manually entered, primary key)
-ID (autonumber, primary key)
- ID (autonumber, primary key)
- FileNumber (liked to the FileNumber of the tblCaseList)
- Name (linked to the ID of the contact in tblContacts)
Because a contact can be associated with several files, I set up the join table of tblFileContacts to link to the file number and to a contact in the contacts table.
I am trying to pull a query with the following information: