If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
reference talbe for records
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? |
#2
|
|||
|
|||
reference talbe for records
On Sep 2, 1:42*pm, buscher75
wrote: 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? |
Thread Tools | |
Display Modes | |
|
|