Having access solve for the best answer, is it possible

[rreinha1]

I am fairly new to access and am curious if this is possible. I have a x number of procedures, I will use 4 as an example, with those 4 procedures I have a reference table that has certain devices for those 4 procedures that need to be compared against the device charges. ie
Procedure
1A
2B
3C
4D

Procedure Device Reference
1A has AAA,BBB,CCC,DDD
2B has AAA,EEE,FFF,GGG
3C has AAA,HHH,III,JJJ
4D has FFF,KKK,LLL,MMM

Device Charges has
AAA,III.LLL.ZZZ

Is there maybe a case statement that I can use to have access try to solve for the best combination of the devices with the procedure to give me the most matches possible and not match say AAA with 3C and LLL with 4D giving 2 out of 4 matches, instead of the result AAA with 1A,III with 3C, and LLL with 4D, and flagging ZZZ as not a match or it matches 3 out of 4
Im not sure if this is the best place for this but any help is greatly appreciated and if more information is needed please let me know thank you for your time in advance

 

[The_Doc_Man]

Search for DATABASE NORMALIZATION in Access, this forum, and through GOOGLE or some other search engine. You are starting with abnormal table structures. This will only make your job harder, not easier.

It is possible to count matches - but it would be easier with normalized tables.

 

[rreinha1]

I guess my example was a poor one, I have 3 tables one with procedure charges on a patients bill, that procedure charge has another table with 5 or so devices, 1 of which is required for that procedure charge and should be on the bill under devices charged, and the last table has the devices charged on the patients bill, I am looking for missing device charges, a device can be used for different procedures, I am trying to see if access can give me the best possible combination for the devices and procedures charged(most matches), and flag the ones that dont match up(say 5 for 5) does that help a little more

 

[The_Doc_Man]

My answer stands.