How would you accomplish this task?

[pathetic]

I'm a beginner, please tell me if you can suggest a quick and efficient method of producing these results.

Table or other tabular display that queries my access database, presents to the user:

Column 1: State(Florida, Georgia, Texas, etc)
Column 2: City (Tampa, Atlanta, Dallas, etc)
Column 3: County (obvious)
Column 4: file.pdf (unique files names)
Column 5: Check box (yes/no)

Functionality:
must be able to insert/delete/edit (and this action is tied into the database), must be able to select yes/no in the checkbox (and this action carried through to the database), must be able to launch any selected file name present in column 4 (these file names cannot be hardcoded into the application).

I have been able to accomplish all except launching the hyperlink files using CFGrid. Is there a better way... for a beginner... to accomplish this?

Or am I on the right track with CFGrid? Can anyone help me with my problem launching the hyperlinked files in CFGrid?

 

[TruthInSatire]

if these are all inputs its kind of a pain in the butt.

you'll have to run a loop obviously.

each field will have to be called something like

State#loopIndex#
City#loopIndex#
County#loopIndex#
file#loopIndex#
yesNo#loopIndex#

the easiest way to do your add/edit in one shot is to delete all the existing rows in the db and re-insert them. (this isn't very efficient though)
your insert will be in a loop using evaluate("form.state"&loopIndex)

if the file is an input field and you want them to be able to click on it you'll need a button or link that says "view file" or something to the side of it. Then you'll have to use some javascript to pull up the right file.

If you don't ask the right questions, you don't get the right answers. A question asked in the right way often points to its own answer. Asking questions is the ABC of diagnosis. Only the inquiring mind solves problems.

-Quote by Edward Hodnett