I am not a db admin., or a programmer. I do have about 40 printers (25 models) that have toner part numbers that range from one black to several colors.
What programming language or application would be a quick study to build my own ordering wizard.
My thoughts were an Access dashboard, or maybe a browser based application would be easier. I not very family with MySQL but would like this to be almost zero cost other than my time to develop and maintain. (I do have MS Access but have not used it for several years.)
My vision is :
Pick the printer (Model/Serial) and then the toner ordering options would be only toner part numbers that go with that printer. Once the Printer, qty., and toner is selected print to a screen or inject in an email/template.
Right now I have a table embedded in an Outlook template that makes it easy to pick a printer and then a toner. I just wish the toner selection was limited to the toners for that particular printer. Once I pick the printer/toner then I send it to our vendor. (Toner replacement is under contract.) This works smooth with the exception of always needing to look up the part number. I usually order the item and do not handle the toner box. I also don't want to keep asking the helpdesk what the part number was. I considered just making it one cell that had the printer name first then serial, and every toner possible. the selection would look like "Sharp-B350 Ser.AC56789 - Blk NBT420". This will be a long list with each printer listed with the serial number and each toner.
I thought an Access database with the printer model as the primary key then point to another table with qualifying toners. I just wanted a few suggestions before I scrap the Excel embedded table in Outlook. I could use Smart Sheets but the company does not want the extra costs for a subscription.
~ Thanks in advance ~