klixy23
9th July 2004, 11:24
Is it possible to change the main table for multi occurence display session? Form 1 has main table "table.1" and i want to change the main table to "table.2" when user changes to form 2.
Or any other solutions for that?

Hitesh Shah
12th July 2004, 07:47
In Baan IV one can not have more than 1 main table in a session.

I presume the situation in which u need this is for tables having
parent child relationships ( like sales order & lines). In such
case u can have an interactive sessions with different main tables.

If main table io on child table are ok, u should be able to
accomplish the objective with separate forms too.

sachin03
12th July 2004, 07:55
Hi, can you explain how this can be achived? and what do you mean by this

If main table io on child table are ok, u should be able to
accomplish the objective with separate forms too.

I had a similar requirement in which I wanted to base a display session on 2 similar tables, if the record is not found in the 1st table, then the session should search in the second table. There were some solutions provided for this, but when i tried them, they were making the session very slow.

Hitesh Shah
12th July 2004, 08:07
There were no parent child relation ship among the tables. Table was replica of the other in ur case. So in that case it can not work.

Here also no magic is going to work . User will simply fetch the details from parent session in display the same in 2nd form for the first rec of the multi-occ form (sort of ttadv4100m000) .

sachin03
12th July 2004, 09:10
But in ttadv4100m000, both the forms have the same main table. as u have rightly said, in baan a session can have only 1 main table. so how is it possible that the first form is based one table and the second on another table? what happens when the user navigates between the records using next previous, or next set, previous set, how is the system going to fetch records from 2 tables?