Lookup field returning ID not String on page. Please Help!

Lookup field returning ID not String on page. Please Help!

hey all

So I have a page that displays selected product information triggered via a custom function on a report.

It shows the name of the product, price and image

I'm also trying to show the company name of the product, but only get the ID number not the string value.

On the "Add_Product" form, the company name is selected via a Lookup Field that gets its results from the "Add_Company" form

I've made the code in bold that is returning the ID number.

Anyone know what code to add and where to make it show the company name for the product selected.


Thanks, here is my code:


  2. htmlpage ProductSample(empid)
  3. <%{%>    <style>
  4.   .whole_container{
  5.   width:50%;
  6.   float:left;
  7.   text-align: center;
  8.   }

  10. .after-box {
  11.   clear: left;
  12. }
  13.     </style>
  14.  
  15.   <h2 align="center">Mood Board</h2><%prodLst = input.empid.toList();
  16.     for each prod in Add_Product  [ID in prodLst]
  17.     {%>        <div class="whole_container"><%=prod.Product_Name%>    <br> <%=prod.Company_Name%>   <br>£<%=prod.Price%><br>W <%=prod.Width%> - H <%=prod.Height%> - D <%=prod.Depth%><br><%for each rec in prod.Product_Images
  18.         {
  19.             if (rec.Product_Image.contains("/sharedBy"))
  20.             {
  21.                 x = rec.Product_Image.getSuffix("/image/");
  22.                 y = x.getPrefix("\" border");
  23.                 a = "https://creatorexport.zoho.eu/zoho_z/product-catalog/All_Products/" + prod.ID + "/Product_Images.Product_Image/image-download/" + y;%>                <img src = <%=a%> border = "0"></img>            <%}
  24.             else
  25.             {%><%=rec.Product_Image%>            <%}
  26.         }%>        <br><br> <br><br> </div>    <%}
  27. }%>