Restricting Selected Drop Down in a many to many relationship ?
I have a requirement to select a user (standard user table, +800 records) for a new entity ( ie Competition) . One of the attributes on this entity is JudgeID. (ie UserID). There is an additional table (UserRole - M2M ) , which list all the roles that all the users have. Rather than list ALL the users with all their roles , I only want to list the users with a specific role. in this case 'Judge' . Currently i only have 10 judges out of the 800 user records , I have not developed this code as yet , but have a similar development using Checkboxlist function using >belongsToMany etc , but displays all 6 records. I only need 4 records to be display in one case and 2 in another.
Read through the doco , but can not find anything that looks like a 'where = ' . Have also looked at Multi-tenancy (doco) looks over complex for this simple requirement. if anyone can point me in the right direction , would be appreciated LeeB
Read through the doco , but can not find anything that looks like a 'where = ' . Have also looked at Multi-tenancy (doco) looks over complex for this simple requirement. if anyone can point me in the right direction , would be appreciated LeeB
2 Replies