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

Do a search at MSDN for cascading list or combo boxes for the latest techniques for your forms.

Do you need help with the table structure?


mmcdonal

Thank you sooooo much! I've been posting this topic to different Forums all day and this is the first Reply I've received! I'll search and let you know if I find anything. And yes I do need help structuring the data and tables.

Thank you again!

MJB05

Well, maybe I just overlooked it, but unfortunately I didn't see anything that would really help me get going on this? If you have anymore ideas I would really appreciate them!

Thank you,

MJB05

 You might try looking here.