I just built a test file here and it worked as I would have expected. When I set the MYTABLE::userID field to $userID via a script the field formatted as a pop up menu showed the Name of the person, not the ID (exactly NOT what your screen shots are displaying).
I would check the following:
- Make 100% sure the ID you are setting does in fact have a related USER record
- Double check and make sure the field type for User::ID matches the data that is getting set, looks like you need it to be text
- Double check and make sure the variable $userID hasn't been used previously in the script in a way that would make FMP think of it as a number only
- I've seen issues where a varialbe gets used as a number and later text is placed in it but FMP treats it kind of like a number field and seems to ignore text characters even though they are still seen
That's all that comes to mind right now.
My mistake. I figured it out.
I thought I was passing the UUID, but I had concatenated something to the UUID and hand not properly parsed it. It is working as expected now.
Thanks Chad. It was a developer error! I thought I was passing the UUID, but I had not properly parsed it. I grabbed values using eSQL but forgot to specify a carriage return. So, my $userInfo variable looked like this:
Instead of this:
Which, of course, made a difference for my next variables:
$$userID = GetValue ( $userInfo ; 1 )
$$user = GetValue ( $userInfo ; 2 )
It works as expected now. Thanks for taking the time to test.