0

Join fields

Hello,

I'm trying to retrieve information from a joined field and display it in a report. I've tried using the SQL function but I am having no luck. One of the columns that I am retrieving in my report is the row_id (join field) to another table. I want to retrieve information from that other table based upon the row_id that is in my report. I looked at the manual and tried to follow the example but this is not a great plains database. Here is the formula I am using:

=NL("SQL",$C$6, "NAME", "1S=PR_POSTN_ID", I6, "*")

Value of $C$6 = "SQL=SELECT DISTINCT NAME FROM S_POSTN WHERE %FILTER1%=ROW_ID"

The filter1 is the PR_POSTN_ID that I reference in the first line. The "I6" value is the cell that contains the PR_POSTN_ID value. I want to feed that value into my query.

Any ideas?

Thanks.

3 comments

Please sign in to leave a comment.