Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » DBISAM Technical Support » Support Forums » DBISAM General » View Thread |
Messages 1 to 3 of 3 total |
Master/Detail with 3 tables |
Wed, Nov 20 2013 4:57 PM | Permanent Link |
Peter van Mierlo EVENTSOFT | 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 Attachments: TEST.ZIP |
Wed, Nov 27 2013 10:52 AM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | 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 |
Sat, Nov 30 2013 1:38 PM | Permanent Link |
Peter van Mierlo EVENTSOFT | 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 |
This web page was last updated on Saturday, May 4, 2024 at 12:54 AM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |