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)