First, a thanks to those who have pointed out some problems with the Lookup
Wizard. I will now be creating my table relation****ps manually and
employing
list or combo boxes in the forms. Interestingly, in most textbooks for
1st,
2nd, 3rd level ... there seems to be no mention of the "evils" and rather
implies encouragement for use of the "Wizard".
Secondly, I would appreciate suggestions on how to handle "assignments".
I have
tblGames;tblEmployees;tblLocations;tblSupervisors;tblSiteCoordinators;tblInvoices;and
tblRoles. Supervisors and site coordinators can be assigned to more than
one
location. Employees can be assigned to more than one game. Employees can
fullfill more than one role in each game.
I hope this is enough information for someone to give me a suggestion on
how
to efficiently approach this. If not, I can supply more information.
Thanks, in advance.
|
