If there are multiple files to be attached to one of the above records, creation a second table (Timesheets) is recommended. Each record of Timesheets shall be related to the calculations table via a key ID field.
The kind of reporting you are looking for can be done. Look for summary fields and grouped reports. There are some good reads in the "Resources" section, which will help you getting familiar with FM's concepts.
Thanks so much.
Should the Site List and Operative list db's have Key ID fields?
Can you please tell me if it is also possible to have it automatically flag up in one weay or another if a certain date passes?
I.E I want to create a Training Matrix, which records which operatives have what qualifications and when they expire. I want to be alerted (ideally ahead of the time) that Joe Bloggs CSCS Card is due to expire in 30 days or whatever.
All tables should have key ID fields.
FM allows for search in date and timestamp fields. This can also be automated through scripts and calc fields.
Such a training matrix should be no problem. I.e. a field expiration _date can be used to present only expired qualifs (find).
Further action like sending an email to Joe for renewal of his card can be automated through scripting.
Cool - well at least if I know its well within possibility of FM, I can confidently say this is the package to go for.
I need to have Advanced if I want to package this all into a nice GUI front end right? And Server if I want to publish to iOS?
The advanced version has some time-saving features for development.
No you do not need Advanced to build the GUI and it makes no difference on that aspect. But yes, Advanced is strongly recommended for development for a variety of other reasons. Yes, you will need Server or will need to use a hosting service.
Thanks for the clarification Bruce.
You guys recommend any particular books or online resources for the beginner to this like me?
I can see what I want in my minds eye, I just need to fiddle about with it or follow some tutes to allow me to get there asap.
Right now its a collection of FM files with very basic layouts....I need to start linking them together so they can pull values from each other which in turn will feed the reporting side.
Then I need to look at how to tie all that up into a nice pretty GUI
The "Resources" section has some good readings, taking you from the basics to advanced concepts.