When accessing a field in a formula (e.g. {!Product__c}) where the field is of data type Lookup and the object is a custom object, the formula returns some kind of internal record reference (e.g 90333000000E0jt) instead of the record name value as expected.

Is it possible to build a view for a custom object where the user is prompted for the search criteria instead of having to explicitely define the search criteria string in view definition?

For example, would like to prompt the user for the product name instead of creating a view for each product.

- Steve W.

When accessing a field in a formula (e.g. {!Product__c}) where the field is of data type Lookup and the object is a custom object, the formula returns some kind of internal record reference (e.g 90333000000E0jt) instead of the record name value as expected.

Is it possible to build a view for a custom object where the user is prompted for the search criteria instead of having to explicitely define the search criteria string in view definition?

For example, would like to prompt the user for the product name instead of creating a view for each product.

- Steve W.