Combining fields to get different results

A

alicia

Thanks in advance for any input!

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" 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 needs to map 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. IS there any other way to accomplish this
without a crosswalk table? I have minimal programming
knowledge.
Thanks! Alicia
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Mapping 2 fields in one table to one field in another 2
Display query results only if field is not null 3
Combine two fields in a query to get a unique third one. 4
Append two tables into a query 1
How do I combine records from different sources 0
Do I have to have equal number of records in each table to combine them? 14
Query to group similar number combinations? 4
Linking two tables - a bit different 4

Top