In designer tab I have a field
I have gone to the edit tab and selected the field and then selected ViewAs/Edit over on the right pane
The field is using a lookup wizard and I have it all linked abd it works giving me the list of entries I would expect and I have then added a WHERE clause fieldname= ':session.xxxxxx' where this is the variable I want to limit the dropdown list to a single entry based on the data held in the user logon table.(set though security tab "enable database authentication"
This works fine for Add and edit pages but does not work inline
I tried setting fieldname = 1 and it worked fine (1 is what is in the session variable from the user I am using to test)
Do I need to do something different for inline edit/Add
Thanks