I want to designed a database (Inventory for printers)
I just created a form with all the information of the printers, model, etc.
I want to be able to do a monthly inventory of total pages that were printed on each printer.
So all I want to do is every month add a new record to a form where I can add only the PrinterID,Count , and date.
How can associate this information to the information that I already have
I want to be able to browse for a particular printer and when I open the view I want to see the printer information and the activity of each month.
Any help will be appreciated.