On the standard object "Opportunity" I have the standard object "Product" as a related list. This means that a user can press the button "Add" Product on the Opportunity page. When pressing the Add button the user will then get to choose from products which are of the same currency as defined on the opportunity (I run a multi-currency setup). I would like to be able to customize this view so that for example only products with product name that contains the word "Europe" would appear for the user. The reason is because the list of products are too extensive for the end-user to manage. The goal is to have a field on the opportunity where the user fills in a location, such as Europe, and this would then be used to obtain the proper view for this user when selecting a product.

The "Add" button on the product uses Salesforce standard trigger, so this has to be done through visual force. On the product object it is possible to create customized Price Book views of the kind I explain above, but this view cannot be linked to the Add product selection on the opportunity.

My question is how I would go about to create this kind of view in visual force?

Many thanks,

Paddy