Automatically insert/delete multiple records in related table
I'm new to filemaker pro, but have informix database design experience. Hopefully someone can point me in the right direction here. All help greatly appreciated!
Table#1 includes fields:
Table#2 includes fields:
At time of saving entry into Table#1, I need to insert a new row into Table#2 for each date from startdate to enddate inclusive. Status would equal "pending" or "confirmed".
If the record's status in Table#1 is changed at any time to "Cancelled", I need to delete the related rows in Table#2
If the record in Table#1 remains "pending" or "confirmed" but has the startdate or enddate modified at any time, I need rows in Table#2 added or deleted so there remains a row for(and only for) each date from 'startdate' to 'enddate'
FM Pro10 Advanced on Mac