Access Newbie! In Access table how do you get field 2 to display data dependant on option selected in field?

Scenario posed: In Access, you have a table with two fields, 1st field is "Call" and has 2 options (drop down list) 1) Phone during office hours, and 2) Phone out of office hours 2nd field is "Number" and has 2 telephone numbers as options (drop down list) Is it possible on the basis of the... show more Scenario posed: In Access, you have a table with two fields, 1st field is "Call" and has 2 options (drop down list) 1) Phone during office hours, and 2) Phone out of office hours
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!
2 answers 2