Fetch Record

Fetch Record

Hi!

I have a Form Orders_form and an Exchange form.  I need the customers information to populate (ie. Name, Address, Item Purchased) when I provide the Exchange form the Orders_form Order No. I have the relationship setup...i was reading in the resources and found the code i needed but it doesn't work.  What am I doing wrong?

I have this setup on the On User Input of the lookup field Orders.

if (Orders_form[Order_No == input.Orders].count()  >  0)
{
    x  =  Orders_form  [Order_No == input.Orders];
    //input. refers to fields in current form
    input.Name = x.Name;
    input.Address = x.Address;

Any help with be appreciated.