NEEED HEEEEELP in Making child records unaffected by Parent Record data changes
I have been explaiing the function of a parent-child relationship to my boss but he insitis he wants the child records generated from parent records "BE LOCKED" or unnafected once they are duplicated from the parent.
I use a loop script and set field to duplicate sorted records (published in IWP) Here is the scenario:
1) User clicks a button to sort out desired set of records from parent table called (DEFAULT TREATMENTS)
2) script sorts out records, creates duplicates (children) on a separate table called (DAILY TREATMENTS)
3) what my boss wants is to LOCK the DAILY TREATMENT records so that any changes that we do in the default will not reflect on the "published" daily treatments.
Is there a way to lock these records or to make them uneditable or unaffected by parent reocrd changes? All help and replies will be GREATLY appreceiated....Thank you!