I have a Flexgrid which is filled by a Recordset (the contents of which are gained through a SQL query).

The recordset may contain around eg. 10 records, but what I want, is that when a user clicks on one row, the contents of each cell in that row, are displayed in appropriate textboxes.

Example:
When the Flexgrid is populated, it will have (as an example) 5 cells per row...

These cells are named:
CustID, CustSurname, CustForename, CustPhone, CustAddress

When the user clicks on the the 3rd row of the Flexgrid (which is actually the 3rd record in the recordset), I would like each field to be displayed in its appropriate textbox:

txtCustID, txtCustSurname, txtCustForename, txtCustPhone, txtCustAddress


I have thought of 2 ways to do this:
1. Pass each cell value directly to each textbox
2. Pass the row to a recordset, then get populate the textboxes by using the recordset values...


A small problem with both ideas:
What if the user should click more than 1 row, eg. they click 3 rows?
How would I then do this?

Is it possible I could then send the 3 rows (3 records) to a new recordset, and then send each record in turn to the textboxes (and use back/forward buttons to scroll)?


Can anyone please help?