Hello
I am working on a dbase that helps me retrieve availability information for tools. I am relatively new to dbases and am running into some errors
Background Info
ToolGroups: 5 tool Groups A, B, C, D, F
ToolName: Each Tool Group has different tools in it
A tool group contains A1,A2,A3
B tool group contains B1,B2,B3, B4
C tool group contains C1, C2
D tool group contains D1, D2, D3, D4,D5,D6
E tool group contains E1
Year WW: Each workweek starts at 5:00 am SAT and ends on 4:59 am next saturady
I have the following tables
ToolGroup and Tool Name: Linking tool names to their tool groups
Year WW: specifying the from and to dates for each WW For ex. 2012 WW2 starts on 7th Jan 2012 at 5 am and ends on 14th jan 2012 at 4:59 am
Import Data: This table shows the availability information for a tool by timestamp
for ex
Tool A1 from ToolGroup A was idle from 01/03/2012 7:00 pm through 01/04/2012 5:00 am
My objective with the dbase to to give the user an interface that helps in select the following things
1. Tool Group (Can select multiple tool groups)
2. Tool Name (One tool group has multiple tool names in it, I want the user to have the flexibility of a) not having to select the individual tools ie. selecting the tool group only should run the query OR b) the user can select the tool name from the drop down list after sleecting tool group to get more detailed information about the tools
3. Start work week and End workweek: Picking a start workweek and end workweek in the form should retrieve records which fall between the two dates represented by the workweeks for Tool Group and/or tool name selected prior.
Upon selection and querying the output should be in the following format
2012 WW2
Tool Group A was
IDLE for 30%
IN REPAIR for 40%
PRODUCTIVE for 30%
or the following
2012 WW2
Tool Group A
Tool A1
IDLE for 50%
PRODUCTIVE 50%
Tool A2
IDLE for 10%
IN REPAIR for 90%
etc
Any help would be greatly appreciated.