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

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Sign in to follow this  

×
×
  • Create New...

Important Information

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