My program tree looks like

Demoapp
----Forms
------Add Data
----------Contacts
---------------common
---------Stuff
---------------anotherform
--------Information
---------------Info
etc..


I am trying to use @xlookupsourcelist()

page 26 supplement 1.1


I am in the form info and am using on element exit from a field called company to match a field called coname in the form named common

When the company is exited I want to use @xlookupsourcelist() to return a number of fields (similar to the sample file sesame seasons using an @AccessStringArray

I am having troubles with the use of the @xlookupsourcelist()  I have


vInfo = @XLookupSourceList(@FN, Company, "Common!Coname", "first;co_street;co_city;co_State;co_Zip;co_Ship_street;co_Ship_City;co_Ship_Sta
te;co_Ship_Zip")


I have also tried
vInfo = @XLookupSourceList(@FN, Company, "contacts!Common!Coname", "first;co_street;co_city;co_State;co_Zip;co_Ship_street;co_Ship_City;co_Ship_Sta
te;co_Ship_Zip")

and also

vInfo = @XLookupSourceList(@FN, Company, "contacts!Coname", "first;co_street;co_city;co_State;co_Zip;co_Ship_street;co_Ship_City;co_Ship_Sta
te;co_Ship_Zip")


Should it be common or contacts in the form_name ext key section.

(I have declared my variables and have other programming for the @AccessStringArray)

When I use Writeln(vinfo) I get a blank box so I believe my
@XLookupSourceList(@FN, Company, "Common!Coname", "contactt;street;city;State;Zip;Ship_street;Ship_City;Ship_State;Ship_Zip")
Is not correct.

Any help would be great!

I believe I've seen the entire command fail if 1 element name is incorrect, or if you put a semicolon at the end of the line. (if I remember correctly)

It takes some practice.

Steve

Bob,

Thanks for the confirmation. Perhaps in a future version we'll see commands like this become a bit more forgiving.

I'd like to see the command return a blank value for the 1 bad LE name, rather than simply failling completely.

Just a thought.

Steve

Erika,

Good point. Thanks for the explanation.

Steve