New records

  • Thread starter Thread starter Lee
  • Start date Start date
L

Lee

We have a table with our information (>1700 records,
about 10 fields).

We will frequently want to add new records. We can use
the starred record in Forms View to add the new record
there, but what we'd like to do is have a drop down list
of permitted values in some of the fields, such as the
staff member assigned to the job.

We can create a form just for adding new records and this
form would give us drop down lists by using look-up
tables. But how do we add new record information
inputted in this manner to the bottom of the existing
data table?

Is that what an append query is for, and, if so, can we
design the append query to automatically clear itself
every time its contents get added to the main data table?
 
Lee
You are right, that's what you call an append query
You could have the form pick data based on lookup tables, these lookup tables need not be hardcoded, you can populate the forms based on the actual data also..
Just play around with the lookup property.
 
Back
Top