Open Dental Forum

Hello Team,

I want your guidance on, what is the direct relationship between employee table and provider table. We tried thinking of a connection via email or ProvNum, but no success. Also tried via FName and LName, but it is again not fetching proper data if there present a preferred name in provider's data.
Please guide.


Thank you.

Good Morning,

The best option for finding a relationship between the provider and employee table is the userod table. It contains a FK to both provider and employee, but it is worth noting that it is possible to have multiple userods attached to a single provider. See https://www.opendental.com/OpenDentalDo ... xml#userod for more information.