Is it possible to return only unique values in a portal.
I have a table of contacts, each record as a company_id field and address fields. I have created a self relationship based on the company_id. This enables me to show a portal with all the addresses available for a particular company_id.
However, I would like to only show the unique addresses.
Can this be done?
can’t you just make a tabpanel of contacts->company
and then have there a portal: company->adresses?
I am showing a portal with all the contact addresses within a particular company. (i.e. there are different branch/division addresses) There will be several contacts with the same address, and I wan’t to show only the unique addresses in the portal so that the user can select a particular address to populate the address fields.
Will save the end user having to type in the same address over and over.
Also, if there are a hundred contacts with the same address, I will get one hundred portal rows.
what you could do is place tableview (build on adresses) in a tabpanel (so not a portal). Do not base it on a relation so that you have to fill the foundset youreself.
On recordselection of the main form you will fill the tableview with a custom query. (select distinct(adressid) from contact where company= ?) or something like that.