Hi,

Let’s say I have 2 forms that are linked to each other in a 3rd form.

On a html page I show information from fields in Form 1.

For example Form 1 is Product categories, here are details listed about this category.

Form 2 has the products. Products should be able to be assigned to more than 1 category (unlimited).

Form 3 is the linking form. A records contains a lookup field to a product, and a lookup field to a category.

On the html page I want to show next to the details of Form 1, an embedded view that lists the products that are linked to that category.

In the parameters of the Zoho component (view of Form 3) I can write: &CategoryID=3445443334455662.

This only works if I have the column CategoryID shown in the Report of Form 3 (set in Column Properties, settings of the report).

This long idnumber has no meaning to the user and clogs up all more important information.

The user can click on the column > hide, but I would like it to be shown like that on loading the view.

<div elName='zc-component' viewLinkName=‘products_to_categories' params='zc_Header=true&CategoryID=<%=category.ID%>'>Loading View...</div>

(category is variable containing the record data of a certain Categories form record)

How can I show an embedded report in a html page, filtered on a lookup field ID, without this ID field visible in the report? 

Thanks,

Peter