Nic

See this example on how to create a secondary entity based on a view

community.sagecrm.com/.../a-trick-to-expose-an-external-table-through-sage-crm-s-soap-web-services.aspx

And this article to discuss how a secondary entity or custom table can be used within Search Select Advanced fields

community.sagecrm.com/.../how-do-i-add-the-id-from-a-custom-table-table-as-an-search-select-advanced.aspx

Hi Jeff

Thank you for this reply. It was what I was looking for.

To make it a little more tricky, there will be two of these view-based entities in search select advance fields. The second one will be dependent on the first. Will I treat this the same way as described in this article?

community.sagecrm.com/.../use-advanced-search-selects-to-created-linked-selection-lists.aspx

Nic

I think that would work.