x Want to participate? Join the group to interact
Sage CRM
Related
Recommended

Referencing records from a Custom Table in a Advanced Search Select field.

1 minute read time.

In the screen shot below you can see that in my customised implementation of Sage CRM, I am able to associate an Opportunity with an record held in an external database.

The external table in my system is called 'Contacts'

To allow the table to be referenced by an Advanced Search Select I had to add the following translations into the system.

  • family=SS_Entities, code='Contacts', capt_us='Contacts'
  • family=SS_SearchTables, code='Contacts', capt_us='Contacts'
  • family=SS_ViewFields, code='Contacts', capt_us='ContactName'
  • family=SS_IdFields, code='Contacts', capt_us='CompanyId'


Once the translations have been entered then you should be able to define a field as an Advanced Search Select and see 'Contacts' in the entity drop down in customise fields.

Then you add a list called 'ContactsGrid' and a screen called 'ContactsSearchBox' then these will be used when you click on the search button. And you can put whatever fields you like in the search box and list box.
In the list box, set hyperlink on the Contact Name (or whatever field) to Opportunity (for example) and it will do some clever stuff to go back to the calling screen.

See also: Creating a Search Select Advanced Field that links a CRM table to a Parent Table in an External Database

Parents

  • Jeff:

    I need some assistance in modifying an existing SSA field for companies with related companies.

    On an Opportunity for the field oppo_primarypersonid, a SSA field is used to display a list of people for the opportunities associated company. In this scenario, the company has related companies associated with it and they are defined in the table RelatedEntityData. It is a parent child relationship (i.e. Parent = Corporate Child = Location)

    The users want to be able to see all people from the related parent and child or the related child and parent when making a selection for the SSA field for oppo_primarypersonid. Therefore, if the user was on an opportunity for the parent company, they would see all the people from the parent and child. If the user was on an opportunity for the child, they would see all the people from parent and child. In the oppo_primarypersonid, they want to store the pers_personid in this field. This person might be from the parent or the child company.

    I don't have a lot of experience setting up a SSA field, therefore, I am having trouble wrapping my brain around how I might do this or if I could even do this with a SSA field.

    Am I on the right track with this? I am hoping you can push me in the right direction.

    Any assistance that you could provide would be greatly appreciated!

Comment

  • Jeff:

    I need some assistance in modifying an existing SSA field for companies with related companies.

    On an Opportunity for the field oppo_primarypersonid, a SSA field is used to display a list of people for the opportunities associated company. In this scenario, the company has related companies associated with it and they are defined in the table RelatedEntityData. It is a parent child relationship (i.e. Parent = Corporate Child = Location)

    The users want to be able to see all people from the related parent and child or the related child and parent when making a selection for the SSA field for oppo_primarypersonid. Therefore, if the user was on an opportunity for the parent company, they would see all the people from the parent and child. If the user was on an opportunity for the child, they would see all the people from parent and child. In the oppo_primarypersonid, they want to store the pers_personid in this field. This person might be from the parent or the child company.

    I don't have a lot of experience setting up a SSA field, therefore, I am having trouble wrapping my brain around how I might do this or if I could even do this with a SSA field.

    Am I on the right track with this? I am hoping you can push me in the right direction.

    Any assistance that you could provide would be greatly appreciated!

Children
No Data
Generic Content
Generic Content

*Community Hub is the new name for Sage City