Can I please ask this question, I am trying to zoom to Items-General (tcibd0101s000). It opens/load the session but does not point to the proper record based on the item selected in my row even I mapped the item value. Am I missing something? Like i there is a find.data that needs to happen to retrieve to proper value?

function extern open.items.general()
{
tcibd001.item = tdsmi526.item
start.session(MODELESS, "tcibd0101s000", "", "")
}

Replace the start.session() with query.extend.where.in.zoom() (http://www.baanboard.com/programmers_manual_baanerp_help_functions_sql_query_extensions_query_extend_where) and add the proper where condition.

Hi NPrao,
Thanks for your reply.
Sorry, I cannot follow what you need to happen here as per you recommendation I tried
query.extend.where.in.zoom("tcibd001.item = " & quoted.string(" 8040NTAABZ")) But it does not even load the tcibd0101s000. I am under the assumption that I will use query.extend in the before program of tcibd0101s000 but I cannot do that because we don't have source code for that standard session.

Any more ideas how to load the Items-General Session populated with a value that I assigned to ?

The first think I thought of is this a segmented item - you know where you have to set two fields? The only other things I can think of are related to 4c4. I have to make sure the table is declared and set on the calling side - then call the session and hope it executes the find. Just like you did assuming both tables are declared in the script. Are there other sessions that call this session and it points to the correct item? Sometimes I have to set a zoom.item - export it. I doubt if that is the case here.

Hi,

Here's a simple example of how to do it.

Say I have two fields on my form:-

1. Receipt No (rcno)
2. Receipt Line (rcln)

Now, I want that, when I zoom to Receipt Line (rcln) it should display only the lines related to the Receipt No (rcno) I have selected.

So, on my form I will keep session whinh3110m000 as zoom session for field rcno.

And, session whinh3512m100 for my field rcln.

Now, in my script I will do this:-

field.rcln:

selection.filter:

query.extend.where.in.zoom("whinh312.rcno = " & quoted.string(rcno))

Thanks bhushanchanda and mark_h. That helped me.