Mapping 2 fields in one table to one field in another

  • Thread starter Thread starter Alicia
  • Start date Start date
A

Alicia

I asked this question last week with no response yet.
Does this make sense?

I have a table called "Encounter" with fields "Facility"
and "Customer Type". I have another table
("CrosswalkFacilityLocation) that should map these two
fields and result in a "location" (that is in
the "crosswalkFaciltyLocation table) based on the
combination of the two fields. For example, If the
Facility = A and the Customer Type = 1 (both data
elements are in the Encounter table), then the crosswalk
table maps these two criteria to Location 120.
If Facilty = A and Customer Type = 2, crosswalk maps to
Location 119. If Facility = B and the Customer type = 1,
then 121, etc.

I have tried to pull the two tables in a query and link
the Facility field and the customer type field though get
2 records for every record in Encounter since there are
two in the Crosswalk. table. I'm clearly missing
something. I'm thinkning the crosswalk table is the
answer though unsure how to produce the result? Or maybe
there is an easier way to accomplish this
without a crosswalk table?
Thanks! Alicia
 
Hi,


That seems to be the procedure. If you have two solutions, which one
would you take? or they are the same, repeated? in the last case, just use
DISTINCT as in "SELECT DISTINCT Location FROM ... "



Hoping it may help,
Vanderghast, Access MVP
 
I got it to work. THANK YOU!
-----Original Message-----
Hi,


That seems to be the procedure. If you have two solutions, which one
would you take? or they are the same, repeated? in the last case, just use
DISTINCT as in "SELECT DISTINCT Location FROM ... "



Hoping it may help,
Vanderghast, Access MVP





.
Click to expand...
 
Back
Top