Can someone tell me what I am doing daft.
I am trying to create a record on a button click that inserts two foreign keys. One is fine from a page parameter - the other is trying to insert the unique user id of an email address typed into a text box. Seems straight forward, either Im doing something stupid or there is a limitation on search in the user table? The search criteria is below
And the rest here
It doesnt populate and if I change the criteria to a count it returns zero but the record is definitely in the data table and I have checked for leading or trailing spaces. Is there anything obvious in the above?