Hello Everyone,

I am creating a baan sql query on table tcmcs023. There are two fields citg and dsca. out of which citg is on form as selection field.

I was wondering if there is any way to put a zoom on this query field instead of typing values manually ?

Kind request to guide.

Vishal

Hi,

SQL Queries are meant to be for data validation purpose mostly so the option is not provided to handle any further enhancements. I would suggest to create a print session instead and add the logic required or else, create a print session and provide the form fields and then you can use AFS to trigger your SQL query using the input provided,

To use the SQL query from session, follow this link (http://www.baanboard.com/baanboard/showthread.php?t=65197)