Query to fetch a rating based on another table

[brianeveretthoffman]

Please forgive me, as I am a novice with Access and do not know how to effectively search for the answer to my question.




My database has a Table1 with a list of devices with a relationship to a Table2 that has ‘parent’ devices (that contain information that all of the child devices share). I can create a query just fine to display all devices with the parent information. However, the Table2 has a bunch of fields of type text that are Yes or No on whether the device passes criteria for test. I have a third Table3 that has all possible combinations of testing and assigns each case a rating. I would like my query to use the Yes/No information from Table2 and find the correct rating in Table3 to assign to all the devices.


I had tried translating each yes/no into a binary number that would represent it, but I cannot use that for a relationship to the Table3 because you cannot relate a calculated field.


Please let me know if I can supply more information about my issue and I appreciate your time helping me.

[brianeveretthoffman]

I think I have figured this out myself. I learned how to use a DLookUp on the Table3 to match the binary values and get the rating. Tricky use of quotation marks were needed in order to reference the right Table and field. Thanks anyway.