>I have a single table with these fields:
>ItemNo.,Description,Brand,Quantity,DocumentNumber,Expiry date
>
>the Procedures is in this way for user:
>1- user will write Document Number To Capture data by Remote view From Another system,
>After that he will write an Expir date for each Item No, Then he will save it to Another table Called Prodexp.
>Note: This Procedure is like a Person who writes a bill
>
>2- In Another Form the user will write ItemNo., In grid Will show him all Description,Brand,Quantity and Expir Date for same ItemNo. with deferent Document Number, This Form made it to let user takes from quantity but system should let him takes from nearest expire date until user makes the quantity equal 0, when it become 0 user can takes quantity from next nearest expire date, and so on
OK then, the grid RecordSource is your table alias (I assume) What is your filter expression and when do you apply it to the table? Is it possible to send me your form, table, and all related files so I could take a look?
Nick Neklioudov
Universal Thread Consultant
3 times Microsoft MVP - Visual FoxPro
"I have not failed. I've just found 10,000 ways that don't work." - Thomas Edison