Many to Many - This works (sharing the solution)

ddumas

I have a many to many relationship between accounts and acountholders

an account can have many accountholders and an accountholder can have many accounts.

So, I have created an intersection object called AccountHolderBridge, which has 2 attributes: Account and AccountHolder with .

This works.

I then created a shortcut atrributes in AccountHolderBridge for Account.Name and AccountHolder.Name.

In the account object I created an attribute of AccountHolders of type AccountHolderBridge, and display the shortcut AccountHolder.Name as a table of items.

In the accountHolder object I created an attribute of accounts of type AccountHolderBridge and display the shortcut Account.Name as a table of items.

This worked - The related "bridge" records show properly on both Account and AccountHolder forms.

I am impressed (not with me, but with Aware IM)

Dave

tford

As you continue to work with AwareIM, you'll be amazed at the power you have at your fingertips.

customaware

How about a small demo Dave to assist other newcomers.

Cheers
Mark