Updating Primary Tables from Forms

[Guest_imported]

I'm making a database that lists information on various types of equipment. The main primary table for the entire database is a listing of seven different locations. One of my end goals is to create a report which displays each location and the serial numbers of all the devices at the particular location. Right now I have a table for each type of equipment, and a field in each table for serial numbers which is not linked to any other data. I would like to create a serial number table and then link those values to each equipment table. My problem is this: the people who will be using this do not know enough to, nor do they want to, add new serial numbers into the proposed serial number table. So I would like when they add new equipment on one of my forms (designed off the equipment tables) to be able to add the new serial number to my proposed serial number table in order to maintain referencial integrity. Any ideas would be greatly appreciated!

Paul