reference talbe for records

[buscher75]

I need to create a table that is used in reference to create records for
another table. We have 8 auditors that do multiple audits a month and this
reference table plots the department to be audited by auditor number and
month. Creating the reference table is not the issue.

My goal is to be able to use the lookup wizard to select the auditor, then
another to select the month. After which the person entering the results
could select one of the areas for that month, for that auditor.

I've been close......... but no deal. I've tried plotting the information
3 different ways and still I have roadblocks. Any ideas on how to approach
this?

 

[Piet Linden]

I need to create a table that is used in reference to create records for
another table.  We have 8 auditors that do multiple audits a month and this
reference table plots the department to be audited by auditor number and
month.   Creating the reference table is not the issue.  

My goal is to be able to use the lookup wizard to select the auditor, then
another to select the month.  After which the person entering the results
could select one of the areas for that month, for that auditor.

I've been close.........   but no deal.  I've tried plotting the information
3 different ways and still I have roadblocks.  Any ideas on how to approach
this?

Auditor(AuditorID (PK), FirstName, LastName...)
Department(DepartmentID (PK), DepartmentName (Unique),...)
Audits(DepartmentID, AuditorID, AuditDate)

If you base your form on Audits, then you should be able to make the
auditor and department comboboxes and choose whatever you want... or
did I misunderstand the question?