Help creating a relationship

[Proprius]

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.

[mr_vodka]

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.

[Zero Tolerence]

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.

[Vaughan]

A join table is the way to go.

[mr_vodka]

Here is a link to a demo.

Join Table Link

[Proprius]

Thanks very much. Works great!