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
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