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?
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?