Looking for the correct condition to filter my calendar___steward4 which is databasejoin dropdown element.
The databasejoin is from the steward List which has the following field elements FName, LName and a dropdown element Region.
There is a Concat Label for FName, LName which is working and provides a full name for the calendar___steward4 element
What I am trying to achieve is when an allocation officer logs in, the list of full names which are displayed in the dropdown of the Calendar___steward4 are only those with the same Region value as the allocation officer.
The steward List also has a Yes No element called active
I have had no luck with this one
WHERE {thistable}.`steward4`IN ( SELECT Region FROM steward WHERE Region = ($my->Region} AND {thistable}.active =1)
Thanks
Steve
The databasejoin is from the steward List which has the following field elements FName, LName and a dropdown element Region.
There is a Concat Label for FName, LName which is working and provides a full name for the calendar___steward4 element
What I am trying to achieve is when an allocation officer logs in, the list of full names which are displayed in the dropdown of the Calendar___steward4 are only those with the same Region value as the allocation officer.
The steward List also has a Yes No element called active
I have had no luck with this one
WHERE {thistable}.`steward4`IN ( SELECT Region FROM steward WHERE Region = ($my->Region} AND {thistable}.active =1)
Thanks
Steve