When the user keys a request for work the user can choose a barcode to work on or no barcode.
With barcode process?
A. All request are saved to a work_order table. This includes active and in-active request.
B. I need the system to verify that the item barcode they are entering doesn't have an ACTIVE record in the table.
C. If that barcode exist, is marked with anything besides closed, then I do NOT want it in the table.
Without a barcode number?
A. The user could need work on a wall, this doesn't have a barcode
B. I need the system to say if the value of barcode is null, then always allow add of record.
I have posted in the past something very similar; here is a link to that post:
http://www.asprunner.com/forums/index.php?...amp;#entry24264
Any help is very much appreciated.
Using MySQL and ASP Runner 5.1