How to display information by entering field value

• Wayne Reed

  SSC Rookie

  Points: 28

  More actions

  January 12, 2005 at 7:54 am

  #162982

  I need to create a report, data access page or whatever works...to access information about a specific product by tracking number.

  Simply put, I need to know how to create the lookup field that pulls the data about the tracking number I specify. This data will come from different tables and the tracking number is not unique. I will figure out how to display all of the data if only I can get started here.

  I've tried creating a report in Crystal Reports 8.0, however I have never been able to actually connect to the server.

  I've also started a data access page from MS Access 2003, I can access the records through a query that doesn't return null tracking numbers, just simply can't figure out how to make the field where you enter the tracking number you are looking for.

  Any help is greatly appreciated. Thanks.

• Steve Jones - SSC Editor

  SSC Guru

  Points: 738043

  More actions

  January 12, 2005 at 9:48 am

  #537075

  Not sure about Crystal or Access, but here's some basic ASP tutorials. http://www.realworldasp.net/

  You really have a two part process. One to get the lookups and display for the user to choose, and one for the results based on the user choice. Maybe someone with more Access experience will chime in.

• Wayne Reed

  SSC Rookie

  Points: 28

  More actions

  January 12, 2005 at 10:06 am

  #537082

  Much appreciated. I will check out those tutorials and see what I can learn.

  Thanks very much for the quick response.