update simultaneously a field in a group of records

[Guest]

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

 

[John Vinson]

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?

Sounds like you need to normalize your table. If the Cost is an
attribute of the category, model and vendor and not of the item, then
perhaps you need a table containing category, model, vendor and cost,
related one to many to an Item table.

John W. Vinson[MVP]