Hi. I haven't used Access in a very long time, and especially nothing like the web app / sharepoint feature.
I have a table based around the "Employee" template. I have also created 4 very simple tables (ID & Value) that have various categories (based on previous experience and current skills). Each Employee can be linked to many of these categories, so I've also created a further 4 Employee/Category lookup tables. Again, very simply 2 lookup fields in each (Display Name First Last & Category Value).
To my surprise (in a good way) it added these links into the Employee List View. So I have the ability just from the main employee table to add multiple values from each of the 4 categories.
The final thing I want to do is the ability to filter the employees table, by any of the category values, much in the same way it works for the fields in the employee table.
So if I have two employees:
John (Skills: SQL, Excel, Companies: Microsoft, Tableau), Jack (Skills:Excel, Companies: SAS)
If I was to type SQL in the built in List filter, I'd want it to show me only John.
I can do this in the Employee/Skill Matrix Table View but not in the Employee View. Any ideas?
I have a table based around the "Employee" template. I have also created 4 very simple tables (ID & Value) that have various categories (based on previous experience and current skills). Each Employee can be linked to many of these categories, so I've also created a further 4 Employee/Category lookup tables. Again, very simply 2 lookup fields in each (Display Name First Last & Category Value).
To my surprise (in a good way) it added these links into the Employee List View. So I have the ability just from the main employee table to add multiple values from each of the 4 categories.
The final thing I want to do is the ability to filter the employees table, by any of the category values, much in the same way it works for the fields in the employee table.
So if I have two employees:
John (Skills: SQL, Excel, Companies: Microsoft, Tableau), Jack (Skills:Excel, Companies: SAS)
If I was to type SQL in the built in List filter, I'd want it to show me only John.
I can do this in the Employee/Skill Matrix Table View but not in the Employee View. Any ideas?
