I have a table billings and a table receipts with a one-to-many relationship. Since there can be many receipts for each bill, I want to make a calculation field in billing that will show the last receipt payment date.
In receipt, I have an aggregation field cLastPayDate as the maximum of the receipt table field datepaid
In billing file I have a calculation datetime field called cLastPaidDate defined as return billing_to_receipts.cLastPayDate;
Is this the right way to do this? The field in the
billing table is blank for all records.