How to use a field on a layout in a query
I have a query where I'd like to display the (one or more) roles a particular user has. But, to narrow down the query, I need to use the current user value from one of the form fields.
I've tried adding an additional where clause that references the table field, but that doesn't work since I'm basically saying where user = user.
What's the trick to reference a form field and say something like:
u.user_name = <user value on form>
Hope this question is clear.
Look forward to suggestions.