Skip to Content

AUTO POPULATE FMS

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 !!

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Jun 08, 2017 at 06:34 PM

    fms.png

    And the formatted search is set up as attached.

    Add comment
    10|10000 characters needed characters exceeded