Forum Discussion
MCFNeil
9 years agoQrew Captain
Joshua,
Rather than making a reverse relationship, I'd recommend making a joined table.
Call it something like "Practice Providers".
Each Practice will have many practice providers
AND
Each Provider will have many Practice Providers.
Then you can have multiple assignments and gives you a lot more flexibility for reporting, and appointment setting.
Rather than making a reverse relationship, I'd recommend making a joined table.
Call it something like "Practice Providers".
Each Practice will have many practice providers
AND
Each Provider will have many Practice Providers.
Then you can have multiple assignments and gives you a lot more flexibility for reporting, and appointment setting.
MCFNeil
9 years agoQrew Captain
If you are going to go to the trouble of all those reverse relationships, you might as well just flip the original.
So make Each Provider, has many Clinics, and make that 4 or 5 times.
**Still not recommended to handle it this way, but if you are going down that path, you might as well cut it down.**
So make Each Provider, has many Clinics, and make that 4 or 5 times.
**Still not recommended to handle it this way, but if you are going down that path, you might as well cut it down.**