HELP! i need an answer!!

S

Sparky

I have two tables. One is a list of vehicles, and the other is a list of
duties for the day. I was wondering if it is possible for Access to alocate
these vehicles to the duties, in a seperate table automatically. Can anyone
help me, as i am quite new to this program. Thanx
 
S

Sparky

Thankyou for taking the time to reply.
The vehicles all have a code to determine which type of vehicle they are.
The duties all use the same code to determine which type of vehicle they
require. However, i have more vehicles than duties, and vehicles are marked
as available, or off the road. I want the computer to allocate the vehicles
that are available to the duties.
 
S

Sparky

The allocation would run on a daily basis, and only one vehicle would be
required per duty.
Unmatched vehicles would need to be marked as 'spare vehicles'. The user
would need to be able to update the allocation during the day if, for
example, a vehicle breaks down. The spare vehicles could then be manually
assigned. Note it would also be possible that there may not be enough
vehicles available to work all duties, and the system would need to show this
to the user.
Thanks for your help.
 
Top