Newbies brmadore Posted February 14, 2001 Newbies Share Posted February 14, 2001 We have three database files currently to track mediations. The first is a Case database file with all information related to cases. The second is a Mediators database file with mediator contact information, etc. The third is a join file (I think) with a record for each time a mediator shows up in a specific case from the Case file. There can be up to 3 mediators per case. Okay, the Case file is set up with a portal to the join file so that we can enter a mediator for the specific case and a record is automatically created in the join file. This works fine except for one thing. Each case may have up to 4 mediation sessions. I'm trying to find a solution so that we can enter up to three mediators per session and have separate records in the original join file so that we can track the number of hours each mediator spends. Am I making sense? I tried creating a fourth file which has separate records for each session. In other words the Case file portals to a Session file which portals to the original hours join file. A one to many to many chain. It doesn't work (surprise) and I wonder if I'm barking up the wrong tree or just have my relationships set up incorrectly or...? Thanks for any help you might be able to provide. Barry, St. Paul, MN Link to comment Share on other sites More sharing options...
This topic is 8072 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!Register a new account
Already have an account? Sign in here.Sign In Now