Form and Table linking

[hazeyw]

Hi, i'm trying to get a field to only allow data to be entered that is in a table
e.g. i have a table which has a list of country dialling codes in it. In my form i want to only allow valid country codes to be entered-i.e. the ones which are in the table?
Ive tried coming up with different validation rules but cant seem to do it
Can anyone help?

 

[Bat17]

use a combo box to select the data and in its properties set 'limit to list' to true.
Can can use the wizard to set the box up for you using the dialing codes table.

HTH

Peter