Setting up a tab on 2nd Tier of a one to many relationship.

Classic Servoy
1

I’m a newbie trying to do the following:-

I have a company form on which I have a tab panel with a tab showing all the contacts for the specific company.

I want to add an additional tab. THis tab will show all the emails received from all the contacts listed within the company. How do I set this up?

The relationship seems to be 1 company to many contacts and one contact to many emails. So the emails are on a second teir. However, I can’t see how I can get the tab to show the emails.

MerMer

2

Hi MerMer

‘listing all the emails rec’d from all the Contacts within a company’

When the emails are received you need to set the Company_ID as well as the Person_ID then you can set up the ‘All Emails’ Tab using a simple Company_ID_to_Emails_Company_ID relationship.

HTH

Graham Greensall
Worxinfo Ltd

3

Graham,

Many thanks for your tip. I presume you mean Company_ID_to_Emails_Person_ID? What are the steps to actually do this? I can’t see how I do it via the relationship set up. I can only see how to link one table with another instead of one relationship to another.

You wrote,

When the emails are received you need to set the Company_ID as well as the Person_ID then you can set up the ‘All Emails’ Tab using a simple Company_ID_to_Emails_Company_ID relationship.

MerMer

4

MerMer

Not knowing your structure I was assuming that when the email is received and matched to the Person you would also pick the Company_ID from the Person record.

Your email record would then have Person_ID and Company_ID as FK’s - this will enable you to list all an individual Persons emails through Person_ID and all the emails to all the Persons in a Company through the Company_ID.

Hope this makes sense - if not just keep asking :)

Graham Greensall
Worxinfo Ltd