i have to create a form type 3(multi occurence),
problem is data of my header comes from a different table,
and data of my detail(the occurences) comes from another table(based on the data of the header),
now the form displays only one occurenece since the main table that i have taken is the header table.

Need some urgent help, totally stuck over this,
Thanx in advance for ur help.

Baan4 doesn't allow you to have data from multiple tables on one form. You will need to define form fields and assign values to these form fields from the other table (as well as the main table). This entails additional coding, as you need to program the refreshing of form field values for all the allowed events on your form, but this is th eonly option in Baan4 to work with multiple tables on the same form.

Anup,

since, your session has the Header table as the main table so, you can have only as many as occurrences as in the main table.

So, in this case, u can create a display session for listing all the header data. select one record and open a new session that will be created on the child table and export the necessary header data based on which child session will fetch data from the child table.

nvp & ankita, thanx a lot for ur replies

@nvp
do u mean we need to take all the fields(including header fields)
as form fields ????

What tables are you talking about? Usually you can setup a multi-occurance session on the child table and look up parent information. Is this a maintain session or display session?

i used a seperate subsession for the occurences, as told by ankita,

thanx a lot to all of u