Tech or Treat! Write an article about your scariest tech disaster to win gadgets!Learn more

x
?
Solved

Programming: Simple item selection and sorted resource database

Posted on 2015-02-20
2
Medium Priority
?
275 Views
Last Modified: 2015-02-21
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  ~
0
Comment
Question by:PostQ
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 85

Accepted Solution

by:
Scott McDaniel (Microsoft Access MVP - EE MVE ) earned 2000 total points
ID: 40622788
Access could easily handle this.

You'd need a table for Printers, and another for Toners:

Printers
----------------
ID (Autonumber, Primary Key)
PrinterName
etc etc

Toner
---------------------
ID (AN, PK)
PrinterID (Foreign Key to Printers table)
Toner
Description

From there, create a form based on each table (the Wizard can do this for you in Access). With the Printer form in Design view, drag the Toner form and drop it on the Printer form. This will create a "subform". Access should link the two properly, but to be sure check the Master and Child Link Fields for the Subform control and make sure they're set for ID and PrinterID respectively.
0
 
LVL 2

Author Closing Comment

by:PostQ
ID: 40622876
Thank you, it looks like it will work out well.
0

Featured Post

Enroll in October's Free Course of the Month

Do you work with and analyze data? Enroll in October's Course of the Month for 7+ hours of SQL training, allowing you to quickly and efficiently store or retrieve data. It's free for Premium Members, Team Accounts, and Qualified Experts!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Your data is at risk. Probably more today that at any other time in history. There are simply more people with more access to the Web with bad intentions.
Instead of error trapping or hard-coding for non-updateable fields when using QODBC, let VBA automatically disable them when forms open. This way, users can view but not change the data. Part 1 explained how to use schema tables to do this. Part 2 h…
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…
In this video, Percona Solution Engineer Rick Golba discuss how (and why) you implement high availability in a database environment. To discuss how Percona Consulting can help with your design and architecture needs for your database and infrastr…
Suggested Courses

647 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question