I have two Tables, "Shot Data" and "Tracker".
Shot Data includes columns of information about photographs, including their specific job identifier called a RefID. I want the RefID column to be automatically copied to Tracker and, ideally, in the process have any duplicate RefID's removed. That would be a good start.
Just for now, I've tried all kinds of things to get one column from one table copied into another table but I'm having a heck of a time figuring out how to do it automatically without any manual process what-so-ever. Any thoughts?
Pertinent information: the RefID column in Shot Data is a text-formula field, the RefID is stripped from the photograph's filename.