performing a record search and displaying the data in a new form

Question

Hi I'm using sql server 2005 to store my records and i was wondering how can I retrieve a record by performing a search? I've two forms find/search page and find/search results page. A user can enter in data to perform a search and once they click on the search button the data should be searched/retrieved from the database and displayed in a new form (find/search results page). How do you go about doing this? Thanks in advance

Sam Hobbs · Answer

Note that in your original question you said nothing about more than one table. You can do a join in a SQL. Are you familiar with that? If not then look at the articles in this web site.

Sacha Hutton · Answer

Yes I know I have to use SQL but is it possible to grab information from 4 different tables to create one SQL statement? I don't know how it will go about retrieving the data from the database to make it appear in a different form. Excuse my ignorance as i'm fairly new to SQL and VB

Sam Hobbs · Answer

SQL