Query Database Return and Update

  • Thread starter Thread starter SmokinJoe
  • Start date Start date
S

SmokinJoe

I'm kind of new at this...

I would like to query a database by an ID number, return
selected fields for the matching record, and then add
information and add this information to a new record.
Question, would I need two tables to do this... one for
the retreival of the information.. and another to add the
updated information, or can this be doen in one table?

Any pointers on how to proceed would be appreciated.
 
I'm kind of new at this...

I would like to query a database by an ID number, return
selected fields for the matching record, and then add
information and add this information to a new record.
Question, would I need two tables to do this... one for
the retreival of the information.. and another to add the
updated information, or can this be doen in one table?

Any pointers on how to proceed would be appreciated.
Click to expand...

You might want to take a step back.

Tables are not tools for getting data into a database. They ARE the
data in the database! Tables are the repository for data; Queries are
tools to select, sort and organize that data; Forms are tools to
display that data on the screen and let you work with it; Reports are
tools to print it out.

You'll need a table to store your data, a Query to retrieve the record
by ID number, and a Form to display the result. The same form, or a
different form, can be used for entering and editing the data.
 
Back
Top