Sep 17, 2019 10:24 PM
Greetings to all. I’m trying to build a filter that only shows me records from specific items that are linked from another table.
I have two tables linked together. One shows the names of users on my network along with other general information. My second table is a list of licenses and prices per licenses. The license table is linked to the user table so that if a user have 2 licenses I will be able to see which licenses the users has from the user table. There are some other roll up columns that calculate total cost of users licenses.
Every time I create a regular filter on the user table to see a list of specific licenses that I can group by the user department, it treats every combination of licenses as a different criteria. I want to be able to filter specific licenses only. Not sure I’m explaining it the best way. I have images but I guess I can’t upload them on a post
Any help will be greatly appreciated.
Sep 19, 2019 07:17 AM
Hi @Angel_Menendez - I think the answer here is in the base structure and breaking this out a bit more. I would have these tables (I’m assuming you’re talking about software licences here, but that doesn’t really matter):
In the Licences table, you can now filter by a specific software type, e.g. Photoshop:
The department would be (I guess) a field on the People table and this could then be a lookup on the Licences table, so you could do department grouping there too.
Does this give you what you need?
JB