Robert Collins Posted February 17, 2005 Share Posted February 17, 2005 I have a database which I use in my shop for POS. There are 3 main files Invoices Products (holds prices, product descriptions) Stock (holds all products booked in . inc serial number for each record) I have set it up so that when a products serial number is entered (in an Invoice), it checks to see if the serial number is one that has been booked in.If it is not, then a dialog box pops up and tells the user to try again) I would like to go one stage further and not let the user sell a product with a serial number if there is an older one thats in stock. I have tried creating a field in "Invoices" that looks up a calculated result using the Min function which gives me a date(from the Stock file) - but the date it gives is when the first of that product was booked in - not the oldest one thats not yet sold. Sorry if I haven't explained it clearly , but does anyone have any ideas? thanks Link to comment Share on other sites More sharing options...
This topic is 6611 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!Register a new account
Already have an account? Sign in here.Sign In Now