I have parent and child tables. How to I dele...

[John_Henry_Jose]

I have parent and child tables. How to I delete a parent table row, if there is no entry in child table for that particular parent entry. Fox Example: I have a parent table for Account Heads. The child table is called Transactions. Now If I want to delete one Account Head in Master Table, I need to check in Transactions table, if any entries there related to Accounts Head Table. How can I achieve this?

[Aleksi_Alkio]

You could create an action button for delete and if that record doesn’t have any related records, you will show the button. If you have them, hide that button.

[TotalSolutions]

I have a Customer table that is related to many other tables like Orders, Payment Receipts, Pickup/Drop, Logins, Purchased From, Sold To, Invoices etc... Now I want the Customer Row to get deleted only if all the related tables do not have any entry related to that customer. How to I check so many tables in one shot in the "If this condition is true”.

Please let me know. Thank you! 😊🙏

[John_Henry_Jose]

But, how to disable the default delete button, which is there in top right side, if you select more than one entry?

[Aleksi_Alkio]

Open the system actions and modify that delete action with the “If this condition is true”.

[John_Henry_Jose]

Wow… Thanks lot…You saved my life…

[Aleksi_Alkio]

You’re welcome

[graham_howe]

Just use AND to check all conditions are true

	AND()
	Are all true?

[TotalSolutions]

Thanx for your quick response. Can you please give me an example of what would be the expression like? 😊

[SkrOYC]

It depends on your actual schema of tables

[TotalSolutions]

Its simple I have Customer Table and the linked table is Orders so what would be the expression? Please let me know...