Multiple records in a single form

[Dale]

Hi,
I had a form which I used to give the name of a person in each
department who is on call for that dept for that day. All of this
information was stored in one record. Due to some changes that need
to be made I've had to redo my table to make separate records each
with "date" , "dept." , and "name". I would like to keep a similar
form that lists each department and the name is just entered from a
drop down box. This would have each form creating about twelve
records instead of one. How do I make this one form create all the
records.
thanks
Dale

 

[Steve Schapel]

Dale,

Have a form based on your Departments table. And have another form,
continuous view, based on the new table. And then add this second form
to the first form as a subform. Set up the Link Child Fields and Link
Master Fields properties of the subform to the dept field. Have a look
at the Help topics about subforms for more information.

By the way, as an aside, regarding your fields "date" , "dept." , and
"name"... "date" and "name" are both Reserved Words in Access (i.e.
have a special meaning), and as such should not be used as the name of a
field or control or database object. And you should also avoid the use
of a . or any other non-alphanumeric character in a field name, so
"dept." is not really a good choice either.