So, as soon as the researcher changes the status to "purchased," it creates a new related record on Table B and asks the researcher to fill out all the information about the new purchased video. Also, how can I make it towards when the "Video Status" is changed back to "in progress," the related record on Table B is automatically deleted? As to prevent new records from being created if the researcher accidentally change the Status to "purchased?"
This should be a scripted workflow. Give the user a button that says "marked as purchased" so that you script can create the record and show a modal window for the required data. That allows you to validate all that data before you actually create the record.
And the reverse for deleting the record.
Thank you for your answer.
Is there a way to create a script that will always validate the existence of the record depending on the value imputed in the related table?