In main session I am selecting sales order number and position number . Then I am having a fieild prod order number for which I am having zoom session (i.e. displaying production orders from table tisfc001) for which I would like to have records only matching to tdsls041.item from main session.

Help


Shrikant

Hi,

I don't know if this is what you mean, but check out "query.extension" in the before.program section of your subsession.
Hope this will help for you.
Hans.

Hi Srikanth,
There are several procedures to do this. you can export variables and you can write query.extensions.

you can write before.zoom section also.

fields.production.order:
before.zoom:
query.extend.where.in.zoom("tisfc001.mitm = '"&tdsls401.item&"')"
This should work. I am assuming you need tdsls401.item only not tdsls041.item.
Hope this will work for you.
Regards
Rajasekhar

query.extend.where.in.zoom is limited to Baan V. You will be limited to using other things like query.extension and set.min/set.max.

I would like to pass pitem thru main session to follwing zoom session

Screen shot is attached. Where in prodn order 1 the followin zoom session is attached

* tisfc0501m900 0 VRC B40l c4 vir
|* Display Production Orders - Itemwise
|* General_User_Unix
|* 2004-02-24
|******************************************************************************
|* Main table tisfc001 Production Orders, Form Type 2
|******************************************************************************

|****************************** declaration section ***************************
declaration:

table ttisfc001 | Production Orders


|****************************** form section **********************************
main.table.io:
after.read:
if not (tisfc001.mitm =pitem) then
skip.io("")
endif