I am having trouble displaying entries in a repeating group. Can somebody tell me if the following approach can work?
I have an app to manage registrations in an organisation. I created the following database structure:
I defined the type “Departments” which the administrator can create in the setup:
Each department is related to the company of the administrator:
Administrator can register users. These users can be related to multiple departments (Departments2)
When a registration is created, it can be related to multiple departments
Now users should be able to see all registrations were registrations departments list values is current users department lists values. The problem here is that I cannot say “is” because it are lists. I have read about the filter of contrains but every time I try that I end up in a loop. I have no idea what to choose after :filter (More)
So I have two questions
- Is this database setup the right approach?
- If so, how do I filter on departments. Whatever I do, it stays red.