Jump to content
Sign in to follow this  
Proprius

Help creating a relationship

Recommended Posts

Here is my setup. I have one table of Clients, and another table for Cases. Each Client can have multiple Cases, and each Case can involve multiple Clients. In each Case record, there is a field with a list of the involved Clients separated by newlines.

Basically, in each Client record, I want to be able to have a portal of all of the Cases that it is involved in. What would be the best way of doing this?

Thanks, I'm kinda new at this. If I didn't explain something clearly just ask.

Share this post


Link to post
Share on other sites

You will need a join table to do what is called a many to many relationship. There are plently of examples on here as well as other websites. Try a search for +lineitems and you should come across some samples of invoices which have the similar setup.

Share this post


Link to post
Share on other sites

just do an = join from your clientID in the clients table, to the return separated client list in your Cases table, then your relationship is done.

In you client record, you would then draw a quick portal that references your Case table. The portal would then show any cases related to that client.

Share this post


Link to post
Share on other sites

A join table is the way to go.

Share this post


Link to post
Share on other sites

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

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

×

Important Information

By using this site, you agree to our Terms of Use.