hi..anyone can help me?..i have a problem regarding view a record..actually my problem is i want to view a record for certain data only..at first user can see all the data in view report..then user can select which data(colum involve in view table) they want to see..then only the selected data will be appear in the screen..but i dont know how to do that?..could u please help me?..by the way i'm using asp for this coding...tq

hi,

what database do you use?

Regards,
Sherief C. Mursyidi

:):D;):(:(

Hopefully I have understood your problem...

You are currently showing a table of results?
1..When you get your records are you pulling a unique identifyer?
2..Make an element in each row clickable (an icon, text or whatever)
3..In the link pass the unique identifyer as a QueryString value.
Post the link to the same page. My identifyer is called ID and the value is held in a record set called rs Eg:
<a href="pageName.asp?Id=<%= rs(0) %>">Click me</a>
4.When this link is clicked the page will reload (passing this querystring) At the top of your page I would do something like:

<%
   IF request.querystring("id") <> "" then
      'user has clicked the link so run the sql showing the selected record only
   ELSE
      'run the sql here to pull all records (default page view)
   END IF
%>

NOTE : Use the same recordSet name for both queries. This way you only need one loop on your page. It will show all records, or just the one asked for when the user clicks the link

BTW : It doesnt matter what DB you are using, this theory will work either way. From reading your post the connection and the query to show all records is not part of your problem?

Wind is your friend
Matt

i'm using microsoft access as a database