So I have a module that is a pool of say 50k people. A unique I’d is assigned each person. Module A
I have another module that are verified people that may or may not exist with the same unique ID in the previous module. Module B
Is there a way to create a relationship after the fact between Module A and Module B if the unique ID is th same. I tinkered with workflow a bit but the relate field never populated.
Thank you
Would it be a good solution for you to just run an UPDATE query in SQL setting a boolean field to TRUE if the unique id was found on the other table?
This would be fast and easier to write.
You would have to run it periodically, as data is updated. Another option is to run it just once for the existing records, and then use a simple workflow to update only the new stuff as it arrives.
Probably. Good call. It’s only twice a year. Will attempt to create a good query. :blink: