Parent/Child Record Relationship
Is there a way to prevent the deletion of a parent record if child records exist?
Forum Discussion
If you pass a summary up to the parent and it is populated that means there is at least one child record. Using the summary field you can do the following.
Remove all QB delete & grid edit controls.
On the parent add a check box named delete.
Put a form rule that prompts the user if there are child records or hide the delete checkbox until there are no child records.
Modify default reports to filter for delete check box.
Set up a weekly automation or do it manually to remove the deleted parents.
Remove all QB delete & grid edit controls.
On the parent add a check box named delete.
Put a form rule that prompts the user if there are child records or hide the delete checkbox until there are no child records.
Modify default reports to filter for delete check box.
Set up a weekly automation or do it manually to remove the deleted parents.