Values on table or query update when a change is made

[mpaulbattle]

I cannot figure out what I am doing wrong but I am assuming it is how I have set up my query. I have two tables

tblPractices - practice information
ID | ContractName | Mnemonic | PCPorSCPID_FK

tblPCPorSCP - describes if the practice is primary or a specialty practice
ID | PCPorSCP

qryPracticePCPorSCP
ID (tblPractice) | PCPorSCPID_FK | ContractName | Mnemonic | PCPorSCP

The query runs fine, but if we change a practice from PCP to SCP, it changes all PCPs to SCP and this also changes the table value as well.

Am I not to include PCPorSCP field?

 

[The_Doc_Man]

We would need to see the SQL of the query. You can open the query in SQL view and do simple text copy (highlight and CTRL/C, e.g.). Then use the code tags (the pound-sign or octothorpe symbol) to get the code markers in place, then paste the SQL inside the markers (CTRL/V, e.g.).

 

[mpaulbattle]

SELECT tblPractices.PracticeID_PK, tblPractices.PCPorSCPID_FK, tblPractices.eCWContractName, tblPractices.Mnemonic, tblPractices.DBA, tblPCPorSCP.PCPorSCP
FROM tblPCPorSCP
RIGHT JOIN tblPractices ON tblPCPorSCP.PCPorSCPID_PK = tblPractices.PCPorSCPID_FK;

 

[mpaulbattle]

I figured out what i was doing wrong. I was doing it completely wrong. So wrong it is too long to explain. Went back to the youtube video and found my mistake.

 

[The_Doc_Man]

OK, good luck with your project.
Glad you found an answer.