Existing template- add extra category/sorting

[davidelsbury]

Hi there
Hoping you can help, as always

I've downloaded the new, "Resource Scheduling" template from the MS website.
I've adapted it to a somewhat different purpose, using it to schedule crew on concerts and shows. I've treated the people as resources, and the "Customer" field as the show name, so it's easy enough to schedule them in this way.

What I want clarification on, is being able to enter the data seperately. You'll see from the screengrab that it gets rather messy with 7 entries for each person (a week's worth) and then with seperate shows...)

I have created a report that sorts by "Customer", so the output is clear-ish.

Am I correct in saying that all I need to do is to enter another column in each table and link them up, for the actual event ID?

Hope this is clear enough (but probably not....) so please ask for clarification.
Thanks


David

http://www.filesonic.com/file/418155...2011-12-12.mdb

[June7]

I don't think this template quite fits your situation. Maybe one too many tables. Consider this structure:

tblStaff
StaffID (primary key)
StaffLastName
StaffFirstName

tblEvent
EventID (primary key)
EventName
EventStart (date/time)
EventEnd (date/time)
ContactName
ContactPhone

tblEventStaff
ID (primary key)
EventID (foreign key)
StaffID (foreign key)
ScheduleStart (date/time)
ScheduleEnd (date/time)
Confirmed