Listboxes Sub-Listboxes and Table Linking
Basically what I'm trying to do and need some assistance and direction on where to start:
Example:
TABLES:
I need to have a main table tblemployees, a categories table tblcategories, a main privileges table tblprivileges and a subprivilieges table tblsubprivilieges and have them all link back to one employee record for many selected categories, privileges and subprivileges.
FORM:
I wanted to use listboxes to select the appropriate categories, privileges and subpriviliges, for example on an input form have the categories listbox then depending on the selections in the categories listbox have the privileges listbox appear with the appropriate choices then depending on the selections in the privileges listbox a third subprivileges list box would appear with the appropriate choices and finally have all of these link back to the main employee record.
Any help is much appreciated!
Thank you,
MJB05
|