Hi everyone,
I have a table for customers, a table for assets and a table for faults.
Each client can have several assets and each asset can have several faults.
When a fault is closed, an email is sent to the customer with a request for payment for that fault.
I have clients who are divorced and they are paying for the same property.
Their email column in the faults table looks like this now - email 1, email 2
And the same for the column with their first name - first name 1, first name 2
Is it possible to send an email to each of them separately when a fault is closed?