referencing a table to impute data

[UCLA Lorna]

I have a table with of zip codes and it's associated city. I have a 2nd table with patient information. In my form, I would like to type in the zip code for a patient's address and cross reference the zip code table to automatically impute the city name. I've done this before, but can't replicate it.

As a side note, each patient has several addresses, so I would like the zip code finder to impute cities for each address.

 

[John Big Booty]

Perhaps the sample here will give you some pointers.