Quote:


Darn it! you are right. I fixed it, then commented the fix out so I could test the work-around (adding @chr(1)), and didn't get the fix back in in time for testing. My mistake. It'll be in 1.0.2 - you are right.

Very sorry.

Please note that I went back and modified my example to Bill to reflect this change.

Could either Bill Gordon or Bob Scott please post your @XUserSelect statements?

I have:

aa = @XUserSelect(@fn, "Main Form!City", "City", v_start, v_end)

in my "merged" Gems and Customers application, running from the GemTypes form and selecting from the Customers form ("Main Form"). Values are being returned nicely.

Bob,

In your case if you change:

v_result = @XUserSelectR(@fn, "physicians!last", "first", v_start, v_end)

to:

v_result = @XUserSelectR(@fn, "physicians!last", "PhysFirst", v_start, v_end)

It will start working. The "source" argument wants to be the "Field Name" not the "Layout Element Name". So if you look to see what the "data source" is for that LE - that will be the name you want.

Explanation: Because an external database does not have a form open, and any one field may appear on multiple forms as the data source of different LEs, which may or may not share names, we can't know which LE name was intended.

BTW: This is something that may change in a near future release.

Is there a recommended method of creating a multi column selection list or pick list?

What I mean by multi column selection list is the ability to display multiple columns.

In the selection list example followed in previous posts we successfully created a selection list showing last names from another database. The problem here is there could be more then one Smith. So the selection box could display the last name plus the city and state so a user can select the correct one.

I could create a field in the external database that would be made up of name + city + state to use as the selection field but I thought there might be a better method using Arrays or ?? that Sesame has to offer.  Any Suggestions?


What I mean by multi column pick list is the ability to display multiple columns
And return multiple columns. Say we have a selection list for line items. We search on a field called category. The selection list brings up the item number, price, desc, etc. when a selection is made it returns many of the values to the correct fields.

Once again I could have a field in my line items database that is  item number + price + desc, etc and then have it return a key number and then have xlookups run that fill each field but is there a better way?

All suggestions appreciated.

Thanks