Script to color fields that contain identical values
I am building a database that has three tables, parts, products and jobs. Each part is its own record. Each product is a record and contains multiple parts and each job is a record that contains mutiple products.
In the job record the operator keys in all the products and that gives him a list of all the parts to complete the job. Some of these parts will be used on multiple products in the job and will show up more than once. I would like to be able to loop through all the fields in a job record and somehow highlight or color all the fields that contain identical values (identical parts) so that the operator can see which parts are common.
Any ideas or help with this script would be appreciated greatly.