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.
Relation between provider and employee tables
-
beacondental
- Posts: 92
- Joined: Wed Mar 15, 2023 8:43 am
Re: Relation between provider and employee tables
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.
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.