I need to figure out how to create two, separate relationships between two tables (based on two fields)-- I have attached the DB. If you look at my relationships, I have "BCBS No CH No Anesthesia" and "FDN Charges"- I need to apply "FDN Charges" to every record in "BCBS No CH No ANesthesia" in my Query ("AUDIT") "BCBS No CH No Anesthesia" has 136,965 Records but when I apply FDN Charges, my query yields 141,877--- The Query is replicating records- But I need a one-to-many relationship between both joined fields (CPT and Be_taxid)- Both CPT and Be_taxid must be equal to apply the "FDN Charges"

Any suggestions on how to fix the relationship? I appreciate any thoughts--

I had this problem when trying to create a master table from many smaller tables...however, I am not able to download your attachment. Getting an error which says the file cannot be found. If you can email I can take a look at it.

I will try to reattach- I also emailed it to you - i think my file is too large and if i delete records then I can't tell if the query is working correctly