Skip to Content
0

AUTO POPULATE FMS

Jun 08, 2017 at 06:31 PM

25

avatar image

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

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Deepika N Jun 08, 2017 at 06:34 PM
0

fms.png

And the formatted search is set up as attached.


fms.png (25.9 kB)
Share
10 |10000 characters needed characters left characters exceeded