multiple combo boxes

[mr]

I have 3 tables:
1- detailing categories of staff
2- detailing overtime rates (ie before 16.00hrs, after 16.00hrs and
weekends)
3- detailing a list of the staff and monetary values of overtime
rates.

I am trying to select on a form the category of staff, in a combo box,
then the overtime rate, again in a combo box and want the third box to
automatically select the correct rate.

I am fairly new to Access, and am working in Access 2000.

Is there an easy way to achieve the above?

Any help greatly appreciated
Many thanks
Martin

 

[Svein Petter]

2 questions occur to me...

Is the selection of overtime rates depending on staff categories?
Is the selection of monetary values for overtime depending on staff
categories and/or overtime rates?

Last, it would be helpful to know the relevant fields (including table
dependency key fields) and how the selected fields are stored (as text, as
an ID number et.c.)

Svein.

 

[mr]

Svein,
All staff categories have differing rates of pay which are detailed in
the third table. this is constructed with 4 columns named:
Category of staff, before 1600hrs, after 1600hrs, and Weekends. The
rates of pay are the lised against the category of staff. so they are
all dependant upon each other.
The field Category of staff is text, and so are the overtime rates.
the monetary values are set as numbers.

thanks for any assistance.

Martin