General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
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
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only