>I'm trying to design an appointment app. for my office and am struggling with table design. Usually this is the easiest part.
>I want to break the day into variable time increments (ie 10,15,20 minutes slots) and have separate schedules for 3 different people. The data would be display in grid form.


Ken, this bears some resemblance to my resort reservation app.

The point I would like to pass along is whether a record exists for every possible slot. I found it very useful to create a "dummy reservation" for every week and unit whether or not they had been spoken for. This made searching for unused unit-weeks much more straightforward since I was searching for actual records rather than implied records.

All reservation records have tStart and tEnd fields and a unit number field which roughly corresponds with your person id.

I can split weeks into days (3-4, 2-1-4, etc.) and merge days back together if needed.

Peter Robinson