I'm currently working on a custom search on OE0101 (Enter Orders) that pulls a contact's first and last names (cicntp.cnt_f_name, cicntp.cnt_l_name), but want to limit it to only contacts for the selected customer. I have cicmpy included in the search, and my two tables are linked together by the cnt_id field.
In the "Where" box, I currently have "WHERE cicntp.cnt_f_name IS NOT NULL AND cicmpy.debcode = ?". I would like the cicmpy.debcode to be equal to the Customer.text value on the Macola ES form. Any ideas on how to set this?
In the "Where" box, I currently have "WHERE cicntp.cnt_f_name IS NOT NULL AND cicmpy.debcode = ?". I would like the cicmpy.debcode to be equal to the Customer.text value on the Macola ES form. Any ideas on how to set this?