Fill in a field based on input of data in another field
Hi,
I'd like to know if this can be done without VBA, since I'm not familiar
with programming....Access 2007
My user has a table that contains countries: [tblAwardCountries]. When she
enters a value in her [PermanentCountry] field, she would like the database
to check to see if that country exists in [tblAwardCountries]. If it does
exist, she would like another field to automatically update to "Eligible for
Award".
Can this be done without programming? I thought of the IN operator, but
there are too many countries to have to type into the expression. Using a
table will be easier to keep updated.
Thanks for any suggestions!
|