Think of this as similar to an invoice, but instead of listing different items/services to purchase on one invoice, you are listing different work outs to define one excersize regimen.
The same set of related tables and a portal for listing items selected would work for either. Your FileMaker application comes with an Invoices starter solution that you can look at for ideas.
The key concept is that you need one record for each work out that you might select for setting up an Excersize Regimen.
Stripped down to basics, you'd need:
Regimens::__pkRegimenID = Regimen_Workout::_fkRegimenID
Workouts::__pkWorkOutID = Regimen_WorkOut::_fkWorkOutID
See the first post of this thread, if my notation is not familiar: Common Forum Relationship and Field Notations Explained
In the Filemaker 12 Invoices starter solution, you'll find:
With these tables and relationships, you can set up a portal to Regimen_Workout on your Regimens layout and use a drop down in the portal row to select a specific record from Workouts.
Note that with this approach, you have complete flexibility as to how many workouts you select for a given regimen.
Wow that's a great start. I will need to review your notation.
OK, here is the bonus question...can I format these to print out in a calendar format, either weekly or monthly? I'm sure the answer is yet, but how?
Thanks so much!!
You can set up a calendar format, but the layout design and relationships used can be a bit complex. Also, some newer versions of Filemaker offer options not available in older versions that can simplify the process. FileMaker 12, in particular offers the option of using SQL expression in ExecuteSQL to do things without adding lots of table occurrences to your relationships graph.
Here's a very simple calendar demo in .fp7 format--the file format for versions 7 - 11. Open it from your trial copy's File menu to get a converted copy that you can open and examine in FileMaker 12: https://www.dropbox.com/s/e8d03xvwe8vtz85/Calendar.fp7
I just followed an hour long screencast by youtube user GuyStevens called "filemaker Pro 12 beginner tutorial"
Looks like he is a frequent poster here, but he has not posted part 2. While the initial requirements of the posted thread were not exactly like mine, it is an interesting project and I was looking fowrard to part 2. Part 1 was great!
I think his username here is "DaSaint"
Appreciate all your feedback so far.