Multiple Fields Populating Checkbox

Discussion created by eliavchik on Mar 28, 2018
Latest reply on Mar 30, 2018 by philmodjunk

Hello All,


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!


Screen Shot 2018-03-28 at 2.16.18 PM.png

Screen Shot 2018-03-28 at 2.21.22 PM.png