I have two forms:
Purchase which logs company purchases,
and Cashflow which shows the cash balance of the company.
when creating a purchase,if a decision box called "add to cash flow" is checked, a new Cashflow record is created with the relevant details.
Purchase also has a lookup table to the newly created cashflow record.
when the decision box is unchecked, or the purchase record is deleted, i want the associated cashflow record to be deleted.
I know a bi-directional lookup might assist but it can't be because every purchase record might also have a "tax return cashflow record" so i can't maintain a one to one relation.
I get this error on submission: