I tend to skip the 'make in Excel' bit, unless I'm dealing with people who are so used to thinking in Excel that they can't think any other way (AKA: 'Accountants'.) Even then, I let them show me what they want in Excel and then create straight into FM. I only use the Excel-FM conversion tool whenever the table already exists in Excel. And even then only 'sometimes'.
I draw out the tables I need, thinking of the smallest level I would ever want to report on, or sort by, or search for.
The relationships that will be necessary come next.
Then the layouts.
Then the scripts.
Then I start at the top of that list again.
The important one is the decision on the lowest form of life that will inhabit a table. Make it too low, and I give myself more trouble than I need (although Real Life says this has never actually happened). Make it too high and I have to re-write a whole structural part of the file. (Customers' promises on their Mother's life have sometimes made me bitterly regret taking their assurances as fact.)
Layouts, relationships, and scripts can all be added on the fly if I've got the Table structure correct from the start
That's my two-cents worth
Nice,... Thanks so much.T
The pieces of the puzzle for me are alot clearer and more reassuring, knowing
how others are using the many aspects of FMK.
Thanks so much,GD