I am new to BaaN programming and I am having a problem with which I could use some assistance. I have created a session which uses a multi-occurance type 2 form to display records from the tfgld106 main table onto it. I need to limit the records on the initial forms display to those of a particular account (tfgld106.leac = '11050') and to be able to work from that subset of records. It seems that everything I try returns all the records from the beginning of the table or no records if I set MIN & MAX values to "11050" with the "store.occ.min()"/"store.occ.max()" functions.

Does anyone have any suggestions as to how to limit the records to only this account number? A snippit of my code in the latest incarnation is shown below.

Thanks in advance for your help.

|****************************** form section ****************

form.1:
init.form:
tfgld106.leac = "11050"
get.rcds()
execute(find.data)

|***************** function section *************************

functions:
function get.rcds()
{
select tfgld106.*, tccom010.nama:cuno.nama
from tfgld106, tccom010
where tfgld106.dim3 refers to tccom010
and tfgld106.leac = "11050"
order by tfgld106.dim3, tfgld106.amth, tfgld106.odoc
selectdo
endselect
}

If your maintable on the session is tfgld106 then use the query.extension functionality. set you query.extension to the ledger account you want. Search this board for query.extension to see how it works - there are a bunch of threads on this topic. And if you want to change accounts these posts will also show you how to rebuild your query.

Another option is to use skip.io functionality, but I do not recommend it in this case.