Sounds like data returned from a database query. SQL Yoga returns query data in this format. What I do is I populate a datagrid with the returned array data, then I use a selectionChanged handler in the data grid script to populate whatever I want. In my case I have distinct fields named "fld" & the column name. (I also have buttons and menus similarly named but that's not important now. I then have a populate handler as a back script that I pass the record array to which populates any fields, menus or buttons with the data.
The net result is a system I can use with any data grid data simply by calling the populate command. Further, I also have an Extract command that will take the value in any fields, buttons or menus and populate an array with related names. Now I have a way to read data from a database, present it to the user, gather the results, check for errors which I haven't described here, then update or insert to the database as necessary. If you need to find data, use the dgFindIndex or dgFindLine commands. I have another self contained search object which does hot searches of a data grid so that as you type, the data in the datagrid will be filtered. I copy/paste the object, set a few variables in the object's script to tell it the name of the data grid and the columns I want to include in the hot search and a couple other things, and presto! It just works! Bob S > On Dec 9, 2015, at 05:11 , tkuyp...@telenet.be wrote: > > Hi Mark, > > Either I don’t understand this, or I didn’t explain it correctly… > gArray contains app. 10.000 lines of data > Item 1 is a unique ID > Item 2 contains the supplier > Item 3 contains the main group > Item 4 contains subgroup 1 > Item 5 contains subgroup 2 > Item 6 contains subgroup 3 > Item 7 contains subgroup 4 > Item 8 contains subgroup 5 > Item 9-15 contains productinfo > > I filled a list field with the keys of item 3 > When I click on an item in that list, I would like to see a second list > filled with the keys belonging to the clicked item. > > So when I understand your code, this should be: > on mouseUp > put gArray[the selectedText of field “Maingroup"] into field “Subgroup" > end mouseUp > But this doesn’t do anything… > > What am I missing? > > > Met vriendelijke groeten, > Warm Regards, _______________________________________________ use-livecode mailing list use-livecode@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-livecode
