ACCESS 2002

[DML]

I AM TRYING TO DO THE FOLLOWING: I AM TRYING TO GET ONE
FIELD TO AUTOMATICALLY UPDATE BASED ON THE DATA I PUT INTO
ANOTHER FIELD IN THE SAME TABLE.

CURRENTLY I HAVE BOTH OF THOSE FIELDS AS COMBO BOXES AND
THEY AUTOMATICALLY FILL IN BASED ON ROW SOURCES IN A
DIFFERENT TABLE.

DOES THIS MAKE SENSE? IS IT POSSIBLE TO ENTER "CHERRY
CREEK" IN FIELD A AND MAKE THE PROJECT NUMBER
AUTOMATICALLY FILL IN? I.E., CHERRY CREEK = 3550; ADAMS
CITY = 3659; THORNTON = DV02029.

MY MIND IS BOGGLED OVER THIS!!! CAN YOU HELP?

THANKS!!!