Normal Topic @XLookUp problem (Read 998 times)
NHUser
Full Member
***
Offline



Posts: 320
Location: Amherst, NH
Joined: Aug 2nd, 2010
@XLookUp problem
Jul 23rd, 2012 at 8:53pm
Print Post Print Post  
Help!  I think I'm going crazy....

I'm trying to set an element in my form with the data from another form.  I've done this a hundred times, but I can't see what I'm doing wrong this time!

The formName where the data resides that I'm trying to pull is called SHELF LIFE.  The ext_key is MATERIALNUMBER (no space).  The source element is PURCHASE NUMBER (with space between the two words).  The key is ELASTOMER.

The element in my active form, that I'm trying to set is ELASTOMER1 (no space).

ELASTOMER1 = @XLOOKUP(@FN, Elastomer,"Shelf Life!MaterialNumber","Purchase Number")

Do you see anything wrong??
  
Back to top
 
IP Logged
 
NHUser
Full Member
***
Offline



Posts: 320
Location: Amherst, NH
Joined: Aug 2nd, 2010
Re: @XLookUp problem
Reply #1 - Jul 24th, 2012 at 12:38pm
Print Post Print Post  
Never mind.....

I found my error.  The source element had a colon at the end of it, which I was not putting in my @XLOOKUP statement.

I corrected that error and now it's working fine!
  
Back to top
 
IP Logged