I am developing a site using MS Access and Macromedia Dreamweaver MX.

The way I understand Access databases is the primary key is the index for the row and is unique to each one.

I would imagine that you would reference the primary key row and display the column (reference row 2 but display the third field in that row.

If I would like to display text from row 3 and field 2 how would I do that?

SELECT field2 FROM tablename WHERE field1=3

^^ That's the SQL code you need to use, of course, you have to replace field1, field2, and tablename with their respective values, but I think that is what you are looking for.

You might get a better response in the programming forum.

James