SSA

Creating SSA fields.

Details taken from https://community.sagecrm.com/partner_community/b/hints_tips_and_tricks/archive/2007/06/23/how-do-i-add-the-id-from-a-custom-table-table-as-an-search-select-advanced.aspx

If we assumed that the new table is called Vacancy

Add the following translations,

family=SS_Entities, code='Vacancy', capt_us='Vacancy' family=SS_SearchTables, code='Vacancy', capt_us='vVacancy' family=SS_ViewFields, code='Vacancy', capt_us='Vaca_Description' family=SS_IdFields, code='Vacancy', capt_us='Vaca_VacancyId'

then you should see Vacancy in the entity drop down when you are editing the field to be an advanced search select in customise fields.

Then you add a list called 'VacancyGrid' and a screen called 'VacancySearchBox' 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 Vacancy Name (or whatever field) to Vacancy and it will do some clever stuff to go back to the calling screen.

---