Forum Discussion
MCFNeil
Qrew 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.
JoshuaNorton
8 years agoQrew Member
Thank you both of you. Ya we could always flip the original, but we have other child tables linked to the parent(practice), so things get tricky at that point.
We'll most likely do the consecutive reverse relationships. Thank you both again!
We'll most likely do the consecutive reverse relationships. Thank you both again!