Hi--
I have been running through the tutes and videos, I am getting a handle on relationships, and now I am getting ready to make the plunge. I am building a Job/Time tracking database, for multiple employees, multiple jobs, and multiple products. A job is a yearly iteration of a product, we publish yearly in most cases, so we have product X, job 2005. My first puzzler (for me, not the FM whizzes), not all jobs are divided into the same time periods. Most are published yearly, some quarterly, some monthly. Can a product be feb, Q2, 2005, while most are just 2005?
Anyways the meat of my question has to do with relationships. I would like to track hours according to job, employee, date, product, etc. I am new to the many/many relationship, is this what it is? How many Hours fields in my HOURS table will I need? If I put in an hour on 4/26/05, will I then be able to look at it in multiple contexts like I listed above?
Is the hourly component just a complicated SORT feature, or is it more complex than that?
Well, that pretty much explains my starting point, any help or advice would be greatly appreciated. Overall, the filemaker learning curve has been interesting, trying to think in entities and relationships for the first time is pretty frustrating, but it makes sense all at once, it seems.
Thanks again, my specs are below:
FMP 7.0V3
Win XP SP-2 &
OS X 10.3.9
