hi,

I've the following tables :

- CONTACT with fields ID, LastName, FirstName
- CUSTOMER with fields ID, Name
- CUSTOMER_CONTACT with fields ID, CustomerID, ContactID

I have 1 table which contains ALL contacts and 1 Contact can has 1-or-more Customers (n:m)

The following Master/Details are build :

Table CUSTOMER_CONTACT :
- MasterSource = Customer
- MasterFields   = CustomerID->ID
In this case i can show only the Contacts from a selected Customer ...that works OK

Now i have a seperate Contact form to add new contacts for the selected customer.
When i use the tabel Contact it shows me ALL contact instead of the contacts for the selected customer.
It's normally because there's no master/detail between Customer_Contact AND Contact.
When i create a Master/Detail then it's not working

I have a Contact.BeforeInsert event which appends a record to Customer_Contact.
I have a Contact.AfterPost event which fills :
- Customer_Contact.ContactID with Contact.ID
- Customer_Contact.RelationID with Relation.ID

HOW CAN I MAKE IT WORKING WHEN I ADD A NEW CONTACT TO THE SELECTED
CUSTOMER I ONLY SEE THE ALREADY ADDED CONTACTS INSTEAD OF ALL CONTACT.

Attached a simple demo

Peter,

Your .zip file attachment appears to be corrupted.

But, this is a customer-specific support issue anyways, so please send the
..zip as an attachment to an email to support@elevatesoft.com and we will
handle it via email.

Thanks,

Tim Young
Elevate Software
www.elevatesoft.com

Hi Tim,

I've send the zip file to support@elevatesoft.com.
Thanks for looking at it.

Regards Peter

"Tim Young [Elevate Software]" wrote:

Peter,

Your .zip file attachment appears to be corrupted.

But, this is a customer-specific support issue anyways, so please send the
..zip as an attachment to an email to support@elevatesoft.com and we will
handle it via email.

Thanks,

Tim Young
Elevate Software
www.elevatesoft.com