From -- link to nonexistent node ID 294 --
[quote=mjwilliamsmj]
Very good how-to for Auto List of Values!
Unfortunately, I cannot figure out any thing else from the posting.
I have the following two grids:
Grid named ZipCode.
Item is the "the zip code", with City and State fields.
Grid named Addresses.
Item is "the name", with Street, City, State and Zip fields.
When filling in the Addresses grid, I would like a pop-up to pull from the ZipCode grid, and fill in the City, State, and Zip fields.
I have tried to just get the Zip field to fill-in without success.
The example says to put in the "fields editor" - Item as ZipCode. I have tried that and as ZipCode, and Zip from ZipCode without success. Whatever I put in the box becomes the TEXT for the lookup!
The pop-up help, by hovering the mouse pointer, over the 'auto list field' indicates using "SQL ....".
Could you post a more detailed example of the above?
[/quote]
Comments
I've been trying this for a…
I've been trying this for a few hours now and can only get one field to lookup and pull out another field from a separate db.
Like
Select fullName from Members
But I cannot seem to get multiple fields from the members DB like this:
Select fullName from Members, First Name from Members, State from Members
I have the code in the editor > Advanced SQL
Where exactly would I place this code?
Hi John, I'd need a bit more…
Hi John,
I'd need a bit more information, but correctly formed SQL should look like: Select field1, field2, field3 from Members
(SQL SELECT Statement (w3schools.com)
Also, if Members is a grid, it must be set to be visible to other apps (in Manage Grids)
HTH !
Pierre_Admin
Oh, you were so right! I…
Oh, you were so right! I added more code than I needed. KISS as always!
Thanks again P.