PDA

Click to See Complete Forum and Search --> : drag item from datalist into cell on flexgrid?


ozymandiaz2
Oct 19th, 2000, 03:41 AM
I need to drag an item from a datalist (bound to an access query) and drop it into the cell that the user is currently over in a FlexGrid. I don't know how to so it.
To make things a bit more complicated, the data that appears in the datalist is not one but three separate columns from the access db so the list appears something like this:

Private Josh Kostka
Ensign Wesley Crusher
Captain Jean Luc-Picard
(the real one doesn't have anything to do with Star Trek though)

the query that the SQL for the datalist points to is something like:
soldierRank & " " & soldierNameFirst & " " & soldierNameLast

When I drag let's say the entry 'Captain Jean-Luc Picard' into a cell on the grid, I want it to say 'Captain Jean-Luc Picard' in the cell and also I need it to update the three different columns that the cell in the grid is attached to with the new data it has got. What I mean is that if the grid is linked up to a table called job01 then it will put in the following automatically after the drop:
job01.soldierRank = "Captain"
job01.soldierNameFirst = "Jean-Luc"
job01.soldierNameLast = "Picard"


PLEASE HELP! AT LEAST WITH THE SIMPLE FIRST PART!

Thanks