AnsweredAssumed Answered

Automatically entering record set into FMP12 table

Question asked by ianmcarter on Mar 29, 2013
Latest reply on Mar 29, 2013 by ianmcarter

Hi

I'm new to FMP12 but in past I've had extensive experience of Oracle. I would like to know how I can create a set of records in FM using without any user input.

The application is part of timesheet application. Once the user has entered dates for 'Start of contract' and 'End of contract' I would like to give him the option to press a button and generate weekly timehseets for period between dates,

So if he enters 04-Mar-2013 (Start) and 31-Mar-2013 (End) I would like to automaitcally create following records in my Timesheet table.

Start.....................End.....................Days...Status

04-Mar-2013 10-Mar-2013 0 Not entered

 

11-Mar-2013 17-Mar-2013 0 Not entered

 

18-Mar-2013 24-Mar-2013 0 Not entered

25-Mar-2013 31-Mar-2013 0 Not entered

If I were able to manipulate sql I could just create INSERT statement (joining to table static), but I understand thats not possible in FMP12.

 

 

Any help would be appreciated.

Ian

Outcomes