suppose a table conatins records 1,2,3,4,5,6,7,8,9,10
and i have records in other table like 1,3,4,5
then it is easy to get records from main table 1,3,4,5 by using filter function or setrange function....
but i want to get result set from main table like 2,6,7,8,9,10. is there any function to get these type of result or i have to write the logic for it ?
Software Developer (NAV)
assume that table which contain all records is main table and remaining as sub table. take variable = Filter type text
create a function MyGetfilter() return value = text
SubRec.findfirst; repeatfilter := filter + '&< > ' + subRec.code +'&'; until(subRec.next = 0); if(filter < > '') then filter := copystr(filter, 2); exit(filter);
u need to call the above code in page
output := output + code + ',';
until(next =0) just try it once thank you
In reply to pdj: