AnsweredAssumed Answered

SQL not pulling number

Question asked by MikeWile on May 11, 2018
Latest reply on May 15, 2018 by beverly

I have a PRODUCT table that has BookCode = 02212-4. I have a calc field to pull an ID from a related table:

 

Product.png

Here is the info from Freelance_JoinTable:

 

Freelance_JoinTable.png

I am getting a question mark and can't figure out why. The field for the ExecuteSQL is Number. The field _fk_ID from Freelance_JoinTable is also Number.

Outcomes