AUTO POPULATE FMS

[former_member280936]

Hello,

I have created a Formatted search to pull up the "Client ID" field in the OCRD table in the "Client ID" field of the "OINV" table. The data pulls up only when i click on the magnifying glass and not automatically,

below is the query that I wrote.

Please help

SELECT T0."CardFName" FROM OCRD T0 LEFT OUTER JOIN OINV T1 ON T0."CardCode" = T1."CardCode" WHERE T0."CardCode" = $[OINV."CardCode"]

Thank you so much !!

[former_member280936]

fms.png

And the formatted search is set up as attached.