Here is my problem.
In my SQL database I have two tables: “Contacts” and “Mailings” also a many-to-many relation table between them called “Contacts_to_Mailings.”
In Servoy I have a form called “mailing.” In this form I would like to display the details from the “Mailing” table such as mailing name, date, etc. Also I would like a list of the contacts in that mailing which are defined in Contacts_to_Mailings" table.
I have tried creating this form based on the “Mailing” table and created a portal with “Contacts_to_Mailings” as the data provider. When I use this setup the portal’s fields fill up with java.lang.Object@4d2f21.
i don’t know why you are seeing those strange object references. But to do such thing good you have to create 3 forms
one on Contacts, wherey you display everything of a contact
on on contacts_to_mailings where you display the contact tab inside a tab panelone on Mailings , where you display name,date and the contacts_to_mailings inside a tabpanel.
I have a similar situation. I’m working on my core CRM module, which includes a lot of many-to-many relationships.
I can understand how we could use multiple forms to reach through more than one relation. How, though, would we do the same with fields?
I had expected to see grandchild relationships in the dataproviders list when placing a field, or in the “select tabpanel form” dialog when placing a form. It looks like I need to go at this from a different angle.