Dear Baan Experts,
I created a SQL Queries, Kindly advise how to create zoom in selection field but Item code able to auto appear zoom in. please refer to attachement.

Thank you

Hi, you can refer to the attachment reply. Please select which session & main field you want to do the data lookup.

-- Grace --

Hi,
in your dynamic form editor you select the specific field and than select in context menu -> Field Properties -> Register Zoom and there you can set the properties for zooming.
after this, choice register General and than insert into the Initial Value for TO-Field the following function fmax($#). With function fmax($#) you set the ZZZZZZ ZZZZZZZZZZZZZZZZZZZ value for the item.t, for example.

See the attachment!

Best regards
michael

fmchong doesn't use the Dynamic Form Editor. In the screenshot it is the form which is generated when you run an Easy SQL query. You cannot specify a zoom session here. Only for the item number the zoom is generated. That is because of the segmented domain for which the zoom sessions are specified in ttgfd4122m000.

Dear Baan Experts,
Yes, the form which is generated when I run an Easy SQL query. Which mean i need to create new session which has dynamic form instead of SQL-Query to solve my problem, am i right?

Thank you.

Indeed, if you want that kind of zooming, you need to create a session.

Dear JaapJD,
Can I add the field example Warehouse in ttgfd4122m000 so that in form Easy SQL query can appear like item?

Thank you.

No, you can't. It would raise problems is all normal forms with the Warehouse domain.

Dear All,
Thank you so much for the advise and reply.
:)