Global update

[FJM]

I have an established form which has several fields to describe a PARTNUMBER. It has hundreds of records
I want to know if I can make the following changes.
1. Add a new Combo field called PRODUCTCATEGORY - which will describe its type (A,B,C etc)
2. Add a new Combo field called INSPECTIONLEVEL - which will describe the type of inspection required (NI,NII,NIII etc)
3. Automatically fill INSPECTIONLEVEL by choosing a PRODUCTCATEGORY


4. Is it then possible in the future to change ALL examples of a PRODUCTCATEGORY from one INSPECTIONLEVEL to another with a single click e.g CATEGORY A was LEVEL NII and I now want to change ALL CATREGORY A's to NIII

[NTC]

Yes to all. But the method of implementation depends on your data structure as well as the user interface form experience that you are wanting to provide.

[FJM]

Can you point me in a direction on how to do point 4. - the global change for a category level ?

[NTC]

that is an Update Query

[FJM]

Thank you - much appreciated