Filtering a View by passing a parameter

Filtering a View by passing a parameter

Hi,
Here is what I would like to achieve..

I have a table with a list of Customers, eg CustomerX, CustomerY, etc.
I have a table with a list of zoho users which links them to a Customer record, eg UserA is related to CustomerX, UserB is related to CustomerX, UserC is related to CustomerY, UserD is related to CustomerY, etc.

I have a table of orders for each customer, eg CustomerX orders Product1, CustomerX orders Product2, CustomerY orders Product1, etc.

I want UserA to be able to log on and see a list of all the orders for the customer that he is connected to. UserB would see the same view as he is also related to CustomerX. UserD would only see the orders for CustomerY.

In order to achieve this I need to be able to pass a filter parameter to the View of the Orders table. I know I can do this from an HTML page by building the URL for the View that includes the relevant filter and allowing the user to click on the link, but in this case the URL shown on the web page will also show the filter value so UserA can just change the URL to use a different customer name and then he will see the orders for that customer. This is not very secure.

I would like to embed a View in an HTML page and pass it the relevant filter value so that the URL shown does not include the filter value, just as if I created a View that was filtered by a fixed value, such as zoho.loginid. I can't use the zoho login variables as I want to filter by Customer and not by User.

If I can do this then it will enable me to build an application that I can allow many customers to use as they will only see their own records.

I hope that this is clear. Please let me know if you need any more information.

Thanks,

Lee