Forum Discussion
Hi MarkShnier,
Thanks for your reply,
I have used the below formula query, but it is not giving the desired result.
((Size(GetRecords("({9.EX.'"&[Vendor]&"'})",[_DBID_VENDOR_SEARCH]))))
instead it is showing question mark.
Here in the above formula query I'm putting the value of Vendor in Vendor table and searching it's existing value in another table called Vendor Search.
9 is the fid of Vendor in Vendor Search table where as Vendor field is in Vendor table.
Please have a look at it.
Thanks in advance.
Maybe try this syntax
var text QUERY ="{9.EX.'"&[Vendor]&"'}";
Size(
GetFieldValues(
GetRecords($QUERY),3))
- HunnyVinod_Kuma3 months agoQrew Member
Hi Mark,
I tried the above one, but getting the same issue. I think will not work at the time of adding record.
- MarkShnier__You3 months agoQrew Legend
I tested and it works for me. Did you try tabbing out of the data entry field to allow the form to know that you have completed your input?