Check boxes and automatically select based on data from another table.
I am creating a database of users on my network. For simplicity purposes I just want their name and job duties. So Lets say I have Microsoft Office installed. For everyone in accounting they need Word and Excel. For people in the Marketing they have access to PowerPoint and Outlook. So I want to create another table that will have the job titles. Also in that table they will have check boxes that says the application names. I check the check boxes for the person in accounting for their required programs. Now on my main table I pull down a list and select the job title. Based on the preselected applications in the other table those check boxes would be filled out.
How would I accomplish this?
I have created a text Field.
I have created a Checkbox set and a value list.
I created another table.
I created a text field for the job title.
I created a text field for the checkbox set and a duplicate value list.