Hello All,
I'm very new to Access,
and I was asked if it was possible to create a calendar-like layout (Monday -> Sunday)
To manage a truck & driver planning.
And since I have no clue how that'd be done,
I started by trying Google.
And this is where I ended.
I will probably have 2 tables.
Table: Vehicles
- Fleet Number (ID) #### (1 to 4 numbers)
- Registration ID ##-##-## (License plate, Dutch format) BP-FD-71 for example
- Type (Guest / Owned / Rental)
Table: Drivers
- ID (Driver's ID number)
- Name (no explenation needed i assume?)
- Sick (If the driver is ill or not)
- Free (If the driver has a day off, or untill when he has the days off)
I also need to make some sort of rule;
A certain driver cannot be put on a certain truck.
example;
Driver "John Doe" cannot be linked to the "Guest" type truck.
And all of that needs to be put into a calendar-like form,
starting with Monday, ending on Sunday..
If someone from this forum would please be so kind to help me with this,
I would love that person.
Thanks in advance,
ThermalSloth.
Also, I am using Access 2003 on Windows XP.
(the forums are lying! :O)