Two Forms Many Table Relationships

Hello,

I am new to the board and don't do much Database building. However, I now have a need to develop an inventory database. In attempting this, I have created a table for each product.
------------------Section A
Table 1 - Computer Name
Table 2 - Computer Serial Number
Table 3 - Computer Product ID
Table 4 - Printer Name......

Problem 1.) I have created a form that displays each item from those table above but cannot input data.
It says I need to create relationships and I don't understand what relationships is necessary.

------------------Section B
I have another Table called *** Staff
This table stores my records for the company and all relevant items and corresponding serial numbers.
I have also created a form to display each record by employee name.

Problem 2.) I would like to be able to use a combo or list box to show the items from the corresponding tables in Section A so I can use these to populate my data sheet for section B.

I am clueless as to how to accomplish this and I would'nt know where to start if I purchased a book. Please help!!!

Thanks in advance for all of your assitance.

rabbidfnkster

Hi Rabbidfnkster,

You are on the right path. Now that you have created four tables they have to be linked together by a common key. For example, employee id can be a field, and this field should be common in all the four tables you have created. In your case, it could be your computer number. This is how you would instruct a query or a form to look up values between tables using the common key.

To create a combo box, you go to the design view of the form and from the tools displayed on the top you select combo box. It will then give you option, how you would like the data to be populated. For example, you would type in the values in combo box or want the combo box to look up in query or table.

Hope, that is what you asked???

All the best.