Forum Discussion

TroyPatton's avatar
TroyPatton
Qrew Trainee
8 years ago

Multiple Join Tables within an App? Mobile nurse example

Hello QB Community, I'm trying to find the best way to go about multiple many-to-many relationships. To keep it brief,  my company has mobile nurses that complete home health projects for pharmaceu...
App builders
Relationships
Tables and fields
DebbieTaylor's avatar
DebbieTaylor
Qrew Trainee
8 years ago
Troy -

You might want to create a table with multiple joins ... a many-to-many-to-many type of thing.  
One question first:  What is a project?  If it's a contract OR a set of visits for multiple patients, you might need to change the diagram do that patients OR patient visits are directly related to the project.

CloudBase Services has built apps to track home nursing visits for large programs in Massachusetts, New Hampshire and Vermont.  We know these things are complex.  Feel free to reach out to us.

Debbie