AnsweredAssumed Answered

Check boxes and automatically select based on data from another table.

Question asked by WillGonz on Aug 17, 2009
Latest reply on Aug 18, 2009 by philmodjunk

Title

Check boxes and automatically select based on data from another table.

Post

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. 

 

Thanks 

 

Outcomes