I would like to be able to lock specific fields once a certain lookup status has been selected. It's an employee database and employees of a certain type should not have certain info entered. What would be the best way to do this?
Thanks.
I would like to be able to lock specific fields once a certain lookup status has been selected. It's an employee database and employees of a certain type should not have certain info entered. What would be the best way to do this?
Thanks.
edit:
what I want to do specifically is force two fields (which are lookup tables) to return "n/a" values (included in the tables) if a specific value is chosen from a first lookup/dropbox. My best attempt so far (in the Table validation rule):
IIf([membership type]= "RAC",[residency]="3", [residency]= "1" OR "2")
I receive an " Expression incorrectly typed/ too long" error from this
do you have criteria like thise for all your residency types? for example, you have type RAC = residency 3. is there a 1-1 relationship between membership types and residencies?
If so, you can remove residency from the data entry process and replace it with a query:
UPDATE mytable
SET residency = "3"
WHERE [membership type] = "RAC"
...and then so one for each of your membership types.
on a sidenote, try to avoid using any spaces or special characters in your table/field/query names. It's just bad practice and can lead to headaches.