AnsweredAssumed Answered

Automatically insert/delete multiple records in related table

Question asked by ptt555 on Apr 27, 2010
Latest reply on Jul 15, 2011 by JeffPark

Title

Automatically insert/delete multiple records in related table

Post

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:

reference

startdate

enddate

status

 

Table#2 includes fields:

reference

date

status

 

CHALLENGE #1

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".

 

CHALLENGE #2

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

 

CHALLENGE #3

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


Outcomes