I work for a communications company and I need to track our cable modem inventory. I need to create a simple database that lets me enter in the MAC address into stock and then issue that box at a later time to a tech. After the tech has been issued the box, I need to again update the status of the modem to include the cust# where it was installed.
I currently have a modem table(MACaddr), tech table(tech#,techname), and modemhistory(modem#,tech#,techname,job#) table. For some reason, I can't seem to figure out how to make it work the way I want.
I have it setup where the "parts guy" scans in the boxes by barcode and they are entered into the ModemTable. Once in the table I need to be able to choose from the available modems to issue to the techs in TechTable. I think I have that down, but once it is issued, how do I remove it from stock since this is a different table?
I hope this makes sense. Check the attached file for my current attempt at this... please contact me if you have any suggestions... I am new at this and I am working blind at the moment. Thanks in advance.