Table with each record having it's own sub-table???

[gibson2503]

Is it possible to creat a table in Access 2007, in which each record has it's own sub-table? I have a table with the column names being DEPARTMENT, SUBDEPARTMENT, PAYROLL CLERK, ASST CLERK, DEPARTMENTCHIEF, and SUBDEPARTMENTSUPERVISOR. I have another table with the column names being QUESTION, YES, NO, N/A, and NOTES. The QUESTION column is already filled in with 12 questions that I need to ask each sub department. Each question is a different record. I would like to somehow combine these. The end result of what I want to do is to be able to pull a report where I will put in a DEPARTMENT and it gives me a list of SUBDEPARTMENTs, then I pick the SUBDEPARTMENT and it brings up the questions and answers and any notes for that particular SUBDEPARTMENT.

[rvasquez]

Have you tried creating a relationship between the tables. Where your left table is the questions and your right table is the Departments?