Hi
rsernowski,
There is only one table by default in Home Inventory Database. i.e Assets.
and here you want to store the details of maintenance of product and also as you had mentioned that you had many kinds of products available.
so here I suggest you to make a new table named "product maintenance".
if you open the "Assets" table then you will find the field "Category". so it will solve your issue. you have to divide all the products in certain categories. like "Kitchen Appliances", "Electrical Appliances" etc.
I had mentioned the pic of that field below. if you click on that field drop down will open. in which you can see the categories.

These are by default categories. you can also customize it as per your requirement. to customize it open the table in "Design View".
then select the "Categories" field.
then in the "properties" you will see 2 tabs. then select "lookup" tab. in that you will find "Row Source" in which you can find the list of options. you can edit that.

now after editing the "categories". lets talk about "product maintenance" table.
in this table you can create a "product _id" field and you will find that it is also available in "Assets" table.
so make primarykey and foreign key relationship between these tables.
and add the fields as per your requirement.
this is how you can try to manage the data about maintenance.
Regards
Deepak
We are trying to better understand customer views on social support experience, so your participation in this interview project would be greatly appreciated if you have time. Thanks for helping make community forums a great place.
Click
HERE to participate the survey.