This query will return 3 related fields. Physician, Service, and Price. The common link between the two is the TaxID and ServiceCode. So everything should match up (thanks to the inner join). If you want to filter for a specific field/value add that with a where clause and use it as your "row source" in your forms. Another option is creating the query and using the field from your form as part of your WHERE clause. Hope this helps.
Thank you again for all of your help enclosed is the SQL code of my QUERY;
what i'm trying to accomplish is this: say for example the Physician TaxID is equal to Sibley Hospital, I would like a means to automatically reference the SibleyCPT table inorder to choose my Sibley service and price....
SELECT T_Service.ServiceNumID, T_Service.TaxIDNum, T_Physicians.TaxID, T_Physicians.HospitalName, T_Service.SibleyNum, T_SibleyCpt.CPTcode, T_SibleyCpt.Charge, T_Service.ECCcptNum, T_ECCcpt.CPTcode, T_ECCcpt.Charge
FROM T_SibleyCpt INNER JOIN (T_Physicians INNER JOIN (T_ECCcpt INNER JOIN T_Service ON T_ECCcpt.ECCcptNum = T_Service.ECCcptNum) ON T_Physicians.TaxIDNum = T_Service.TaxIDNum) ON T_SibleyCpt.SibleyNum = T_Service.SibleyNum;
thank you in advance
---adigga1