I need to create an application to record jobs, and be able to allocate those jobs to certain people or vehicles. I would like to be able to view a certain person or job, and have a sub-form display the various jobs allocated to them, I would also need to be able to re-assign jobs from one person or vehicle to another if required.

Can anyone tell me if the above scenario is possible, and if so give some pointers as to how it can be achieved.

Many thanks.