create links from a table

[bvav22]

I am working on a project for school, and my part of the project is to create a web page that reads all Artists from a table called 'artists', and then display those artists. then i need to allow the user to click on one to go view a information page about them. The query to show all artists on the table and show it is easy, but i have no idea how i can turn that information into a link to another page. Can anyone suggest somewhere that i can read about how to do this?

[Popgun]

Will you be Inserting the records also?

If No then:

You need to:

1 Create a recordset that pulls artist info by a unique ID

2. Create a page with identifiable fields, make it a repeating region, add a navigation

(e.g. <<Last Record|<Next Record|Next Record>|Last Record>>)

3. Create a link next to each record that something like: "View Detail" that holds the unique ID (passed via URL) to an artist detail page.

 

If YES (meaning you need to create a content management mechanism) then:

You should have

1 Insert Page

1 View Page (repeat region with links to the Edit/Delete page)

1 Edit Page (aka Update)

1 Delete page

1 End User View page (see above)

The good news is you can recycle the view page and turn it into the End User view page quite easily, and you can use the Insert page as the Edit page by removing the Insert SQL and replacing it with Update SQL.

 

These are the basics hope it helps.