Hi
I use a database to manage the items used in a project.
I use an Items table with the fields of ItemCode, Category, Model, Location,
UsePeriod, VendorID and Cost and a related Vendors table with the relevant
fields.
Many of these items are of the same category and model and provided by a
vendor. So it is not effective to type the cost for each item one by one on
each record, but it should be better enter it once for each item that
presents and updates? all the same ones of the same category, model and
vendor after all of them have the same cost.
Do you have any suggestion how to do this?

Thanks in advance
GL