general doubt

dynamics nav

can we use same table names for both main form and sub form..??

jglathe

Yes you can, as long as you mean "same table". Interesting design you have there, though

dynamics nav

how to filter the items by using from date and to date. I want the items sales information between from date and to date??

archer89

you can use field "date filter".

samples:
Item.SETFILTER("Date Filter",'%1..%2',DateFrom,DateTo);
Item.SETRANGE("Date Filter",DateFrom,DateTo);
Item.setfilter("Date Filter",'..%1',DateTo);

then e.g.
Item.calcfields("Qty. on Sales Order");
to get the filtered value.