Hello there,
I am currently updating a database within a working enviroment on one machine in our RMA department. The databases primary function will be allow the user to log each hard drive that goes into our testing station from WD and Seagate. I have made a full working database which to now is fine, but we are getting so many drives in and its taking alot of time to input each serial number.
The problem we have is when a customer sends in hundreds of drive in one RMA we have to copy and paste these details below.
Date Received
Customer
Fault Report
Qty Received
Manufature
What I ideally need is a form that allows me to input the above once, and then scan model number and serial number multiple times, whilst the serial number is primary key to ensure the drive doesnt get retested.
Like a split form design in sence. I have attached a report which is what we need, but have removed all details from it apart from a few fake serials for dp. With the report I managed to display only one records details, but allowed all the models and serial numbers to be displayed, but this time i want to get the database to add all the data to each field in the log.
Im hoping what im trying to achieve is possible, if not could someone give me pointers where to get a peice of software which will do this but for free, as this isnt link to our actual RMA system, its just were seeing muliple drives come back in so where have put this in place, and were hoping not to type the same details loads of times just to get the true result we need.
I am currently updating a database within a working enviroment on one machine in our RMA department. The databases primary function will be allow the user to log each hard drive that goes into our testing station from WD and Seagate. I have made a full working database which to now is fine, but we are getting so many drives in and its taking alot of time to input each serial number.
The problem we have is when a customer sends in hundreds of drive in one RMA we have to copy and paste these details below.
Date Received
Customer
Fault Report
Qty Received
Manufature
What I ideally need is a form that allows me to input the above once, and then scan model number and serial number multiple times, whilst the serial number is primary key to ensure the drive doesnt get retested.
Like a split form design in sence. I have attached a report which is what we need, but have removed all details from it apart from a few fake serials for dp. With the report I managed to display only one records details, but allowed all the models and serial numbers to be displayed, but this time i want to get the database to add all the data to each field in the log.
Im hoping what im trying to achieve is possible, if not could someone give me pointers where to get a peice of software which will do this but for free, as this isnt link to our actual RMA system, its just were seeing muliple drives come back in so where have put this in place, and were hoping not to type the same details loads of times just to get the true result we need.
)
