I have two tables:
t_MCRs:
MCRs_ID
MCRs_DE_ID ( Short text ) this is the certificate field to update
t_Certificates:
Certificates_ ID
MCRs_DE_ID short text, this is where i need to get tge certificate from. It is a pre-populated table of thousands of certificate numbers)
Assigned? Boolean
What would you reccomend as the best approach to apply these certificates to the MCR table ?
Thank you for your advice !
Bill