Apologies for the newbie question, but here we go:
I'm currently tracking shots that have visual effects on a television show and was wondering if you could help me figure out a basic function that would automatically populate a checkbox when two "Visual Effects number" fields (found in two separate tables) are the same.
I currently am running a join table between 2 tables and a "Main Table" The main table is listed below in the screenshot (VFX Tracker).
::Version Number and ::ProRes Version number will both have the same data populated into it.
Example: 101_01_0001_V007 would exist in both of them.
When both of those fields contain the same text, I would like to have a checbox populate with an X.
Does anyone have any ideas on the best possible way to do this?
Thank you so much for your help!