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