how to place a range in a field
I have a field that relates to position numbers of enmployees. employees with position numbers 901001 thru 901199 all belong to the same manager.
I have in the related table the managers name and info for his staff and I have the 2 table related thru the position number.
I need to know if there is a way to place the range 901001...901199 in the field on the managers table so whenever am employee with a position number in that range comes up it will pull the information from my managers layout.