NewDaddy
06-22-2007, 08:34 AM
Hi All
I am sure I have seen an example of this somewhere but for the life of me I cannot find anything and as I am not sure what to look for exactly I thought of posting?
I am putting a employee cost calculation sheet together for managers to use which calculates a post's full cost (i.e. basic pay, National Insurance and Pension).
To obtain the cost of a post the manager needs to make some selections (ie Grade, Scale Point, Full time equiv, etc).
Here is what I would like to do, and seek your help.
On selecting the Grade (from a drop down list) I need a dynamic drop down list providing the scale points for that grade only.
At the moment I have a list of all the scale points and would only like the corresponding scale points to be available for selected grade.
Example of grades and scale points
Grade A - might have Scale points 10 thru to 15
Grade B - Scale points 16 thru 21
etc
etc
How do I go about doing this?
Cheers
J
I am sure I have seen an example of this somewhere but for the life of me I cannot find anything and as I am not sure what to look for exactly I thought of posting?
I am putting a employee cost calculation sheet together for managers to use which calculates a post's full cost (i.e. basic pay, National Insurance and Pension).
To obtain the cost of a post the manager needs to make some selections (ie Grade, Scale Point, Full time equiv, etc).
Here is what I would like to do, and seek your help.
On selecting the Grade (from a drop down list) I need a dynamic drop down list providing the scale points for that grade only.
At the moment I have a list of all the scale points and would only like the corresponding scale points to be available for selected grade.
Example of grades and scale points
Grade A - might have Scale points 10 thru to 15
Grade B - Scale points 16 thru 21
etc
etc
How do I go about doing this?
Cheers
J