Hi James,

Well, the ability to "drill down" from grid to form mode is already built into ASP-db. It's called "both" mode. Just set dbMode="both". You can customize which fields you want to display in grid vs form mode and choose which field is your "drill-down" hyperlink.

If you go to: http://www.aspdb.com/properties

and click on FMT-20 (or 21) you'll see examples of this.

Use the "index,indexanchor" options of dbMagicCell to choose which field is your hyperlinked field.

Also, the example on our main page (click on Live Demos) shows this too.

Hope this helps,
John

------------
James at 7/12/00 5:55:46 AM

Hi everyone,
I'ld be much obliged someone can help me figure this one out.

I'm trying to use magicell to create a hyperlinked cell in the grid view of my search results to be able to jump to a more detailed 'form' view of the same record.

I've managed to get it so that when I click on an entry in my 'title' field I create a link to an URL that references the 'unique id' field- so, if I click on the 'title' of the entry, I jump to an an URL that reads like http:~~aspsearch.asp?id=5. I want this URL to be bookmarkable by users.

I guess my question is: do I have to write a special scipt, called display_entry.asp, let's say, to extract the id from the URL and pass it into the SQL query or am I missing some obvious built-in feature of magiccell or some other property?

Many thanks for any advice, James.