Compare 2 fields to get 3rd field...

[Mobjack]

Hello,

I have 2 tables:

tblProviders
ProviderName
ProviderAddress
ProviderType
LocationCode
FacilityType
Etc...


tblFacilityType
ProviderType
Location
FacilityType

In tblFacilityType, the FacilityType field is a combonation of ProviderType and Location. Each of those fields are alphanumeric. What I want to do is have the FacilityType field in the the tblProviders table to look at the Location and the ProviderType fields in the tblFacilityType table to determine what the FacilityType field in the tblProviders table should be.

Hope that is understandable.

Thanks in advance for any assistance.

 

[Mobjack]

Anyone...please?

 

[RuralGuy]

With the information you have supplied so far, it appears your tables are not normalized. You may want to address that issue first.

 

[Mobjack]

Sorry, I am a newbie. What does normalized mean in relation to Access?

Thanks!

 

[RuralGuy]

Go to this link and search for Normalization!

 

[Mobjack]

Will do, thanks!