Delete a list of related things

Need help Database
1

Hi all,

Struggling with trying to get a list of ‘things’ together so I can delete them all at once.

I have ‘authorisations’ that are linked to one or more maintenance records. I want to put ALL of the authorisations for ALL maintenance records into one repeating group based on the mai nteance records in another repeating group.

I just can’t seem to work out how to do this

Any guidance?

Thanks

D

2

Do a search for Authorisations (constraint: Maintenance Record is in Repeating Group’s List of Maintenance records)

3

So simple… thanks for that!!

4

@dunnydf If your objective is deleting all related items to make sure that your database doesn’t contain any orphan records. I would suggest using triggers to guarantee that the same action happens everytime you delete a parent database record.

5

Thanks Ahmed