validation rule needed

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a pay step field which displays the maximum number of steps for assorted pay grades
For example:
pay plan DP grade 1 has 32 pay steps
pay plan DS grade 1 has 24 pay steps.
Pay plan DT grade 1 has 21 pay steps
The pay step field would display numbers 1-32. for DP, it's correct. For all others, it isn't

I have the correct number of steps for each plan/grade combo in tblJunctionPlanGrade
plan and grade are selected before step, so I have values in those fields to tag the correct entry in tblJunctionPlanGrade
How do I set up a validation expression to make sure the number selected is <= tblJunctionPlanGrade for that combo
Could I set up step to only show the numbers from 1 to the correct number in tblJunctionPlanGrade
 
I'm sorry, but you need to provide a bit more detail. "Have the correct
number of steps in ..." really doesn't describe how you have stored the
information. If you mean that "each step is a record in" and "the foreign
keys are . . .", that's what you need to say, and you need to explain what
information is available to use as criteria when you want to retrieve the
information.

Larry Linson
Microsoft Access MVP


"Precise and concise" questions usually get the best answers.

Desert Bear said:
I have a pay step field which displays the maximum number of steps for assorted pay grades.
For example:
pay plan DP grade 1 has 32 pay steps.
pay plan DS grade 1 has 24 pay steps.
Pay plan DT grade 1 has 21 pay steps.
The pay step field would display numbers 1-32. for DP, it's correct. For all others, it isn't.

I have the correct number of steps for each plan/grade combo in tblJunctionPlanGrade.
plan and grade are selected before step, so I have values in those fields
Click to expand...
to tag the correct entry in tblJunctionPlanGrade.
How do I set up a validation expression to make sure the number selected
Click to expand...
is <= tblJunctionPlanGrade for that combo?
 
Back
Top