Access Newbie! In Access table how do you get field 2 to display data dependant on option selected in field?
2nd field is "Number" and has 2 telephone numbers as options (drop down list)
Is it possible on the basis of the option chosen in field one, to force field 2 to display the corresponding telephone number ie either the office or home number?
Would this be done in a separate query with an IF statement or calculated field or something along those lines?
Can anyone make sense of what is trying to be achieved? Any help gratefully received!