K
KateCee
I know this is very simple, but I want to be sure I am going about this the
right way before I accumulate mistakes on my database, please help!
Overview: This database is a scheduling tool (I know Access is not ideal
for scheduling, but I'm trying to make it work). I have a table of
StoreDetectives who are each assigned to a HomeStore and a FieldManager.
Each HomeStore is then attached to a DistrictManager. I have made each of
the above named tables, as well as a table for scheduling that includes only
days of the week, shift start, shift end, and a store # for each day of the
week (employees travel to different stores).
I will be creating a form to input weekly schedules. After entering
individual StoreDetective schedules, I need the database to be able to run
reports of schedules and total hours by individual StoreDetectives, by
FieldManager, by Store, and by DistrictManager. To calculate total hours, I
will be running a query to calculate this.
The question I have then, is how should I structure my schedule entry form?
I will base the form upon the query used to calculate shift length and total
weekly hours. Therefore, I will be using data from both the Schedules table
and the StoreDetective table. Upon choosing the detective's name from a
combo box, I want to do 2 things:
(1) Autofill the Detective's field manager and home store at the top of the
form,
(2) then also replicate the home store as default for each day of the week,
so that the store number is changed ONLY if the detective works at a
different store.
Please let me know how to go about this! Any help is greatly appreciated.
Kate
right way before I accumulate mistakes on my database, please help!
Overview: This database is a scheduling tool (I know Access is not ideal
for scheduling, but I'm trying to make it work). I have a table of
StoreDetectives who are each assigned to a HomeStore and a FieldManager.
Each HomeStore is then attached to a DistrictManager. I have made each of
the above named tables, as well as a table for scheduling that includes only
days of the week, shift start, shift end, and a store # for each day of the
week (employees travel to different stores).
I will be creating a form to input weekly schedules. After entering
individual StoreDetective schedules, I need the database to be able to run
reports of schedules and total hours by individual StoreDetectives, by
FieldManager, by Store, and by DistrictManager. To calculate total hours, I
will be running a query to calculate this.
The question I have then, is how should I structure my schedule entry form?
I will base the form upon the query used to calculate shift length and total
weekly hours. Therefore, I will be using data from both the Schedules table
and the StoreDetective table. Upon choosing the detective's name from a
combo box, I want to do 2 things:
(1) Autofill the Detective's field manager and home store at the top of the
form,
(2) then also replicate the home store as default for each day of the week,
so that the store number is changed ONLY if the detective works at a
different store.
Please let me know how to go about this! Any help is greatly appreciated.
Kate