Conditional data

  • Thread starter Thread starter Ian
  • Start date Start date
I

Ian

HELP!

I have two tables, one with job roles, the other with
software applications.

On the form, the job roles will be a drop down box to
select the role. I then want to be able to assign and
auto display the software applications assigned to that
role.

e.g. Job role
office admin
finance
developer

software apps
word
excel
access
outlook
frontpage

office admin would have Outlook, word
finance would have outlook, word, excel & access
developer would have all.

any suggestions?

Thanks!
 
It seems to me that you are provided a limited view of your data. Don't you
have tables for employees and employeeSoftware?
 
the data i put on was simply an example of what i wanted
to achieve, and not the actual live data I want to use.
If you think of job roles as employees and software apps
as employeeSoftware, that may help.
 
Are software apps applied to employees by way of job role only or can an
employee have software that isn't associated with their role?
 
Back
Top