Value List question

[guy tanguay]

I am making a Database for staff people, so we can entered our working hours.

Each record content the following:

Name of the Staff - Custom VL of the current staff

Date - Auto entry today Date

Department - Custom VL of the different department

Task - Custom VL of different task

Start - Time you did start working

End - Time you did End working

Total

That's it.

Here the question :

I would like the Pop-up list to showed different "task" depending on the "departement" you did select.

How can I acheive that ?

thx

guy

[sbg2]

I have attached an example, learned a lot myself working through this one. There are 5 tables: Task, Staff, Department, TaskList, TaskList_Department

You define your Departments then when you create a Staff member you assign them to a Department (I assume you have already done this). Then define the items in your TaskList which has a portal to TaskList_Department which will hold which Departments has access to each particular task. On the Task form, once you choose a Staff Member the Values in the Task field are filtered according to the Department the Staff belongs to.

StaffPeople.zip