field value check
I'd like to be able to set something up where a field gets flaged somehow if the value is the same or different in a related table. My example is:
One table "Shot Records" and another "Editorial Records". They both have matching fields for "shot number", "Comp Total Frames" and "Cut Total Frames". I have the table related by the "Shot number" field. I'd like to be able to have somekind of indicator if the value of the "Comp Total Frames" and "Cut Total Frames" is differnet in the "Editorial Records" table.