Basic Validation

[hoodoo]

Hello!



In short words, there are 2 buildings (faculties) - each has certain amount of floors. The rooms in the first building are numbered X00-X60 (X being the floor number); whereas, in the second it's 1-25 in the first floor, 26-50 in the second and so on.

In a table I have to register people assigned to different faculties and rooms. So the question is - how do I make such validation rules, that only allow existing room numbers for each faculty to be entered? I need a validation rule or imput mask that, for instance, doesn't allow me to type "189" if an employee is working in the 1st building, but allows only X00-X60 to be typed. The same goes for the second building - how to I make sure that access doesn't allow "23" to be entered in "Room" field, if the floor for the same entry is set to "3"?

Hope I made this clear,
Thanks


---------------

Edit1: I figured out what to do with the first building. I made a validation rule for the table "IIf([FacID]=1;[AssRoom] Like "[1-4][0-5][0-9]" Or "260";[AssRoom] Like "[5-9][6-9]?")". But I cannot think of nothing that can be done with the second building. Any help?

[JamesDeckert]

I don't think you'll be able to do this with an input mask or validation.
It could be done using the lookup wizard where the field references another table that has a comprehensive list of valid rooms, except the building number is not kept with the room number so this probably won't work either.
It seems like you'll need to check at the form level where the data is being input to look at the building number, then check the room number entered.

[hoodoo]

I don't think you'll be able to do this with an input mask or validation.
It could be done using the lookup wizard where the field references another table that has a comprehensive list of valid rooms, except the building number is not kept with the room number so this probably won't work either.
It seems like you'll need to check at the form level where the data is being input to look at the building number, then check the room number entered.

I'm sure there is a way how to get this done with validation. I've been given a hint that I should use "IIF" for both buildings. I don't know nothing else though.

[Bob Fitz]

IMHO the best place for validation is with code in the forms Before Update event.