Complex form question

C

Chey

I have a form with the following fields
Class Name
Staff person
Start
End
Trainer

I would like to log in the above information and then have a list of people
who took that class. How can I add the above information to 30 or so persons
at one time?

Thanks
Cheyenne
 
G

Gina Whipp

Chey,

Are you importing the information from somewhere so you can just append the
information? Because if ot the only way I know is to add them one at a
time. And you say you have a form, but is the form set-up with Navigation
Buttons so you can Add New, is that where you are having the problem? More
information is needed...

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm
 
J

Jeff Boyce

Forms are "windows" on the data in queries and/or tables.

If you don't describe the underlying table structure, it's going to be a bit
tough suggesting "how" to do what you ask?

By the way, if you have a well-normalized relational database, you would NOT
"add the above information to 30 or so persons". What you'd need to do is
association the IDs of each of those people with the ID for that class...

Here's a very simplified table structure that might fit your situation...

tblPerson
PersonID
FirstName
LastName

tblClass
ClassID
ClassName
ClassDescription
StaffPersonID
TrainerID
ClassBeginDateTime
ClassEndDateTime

trelEnrollment
EnrollmentID
PersonID
ClassID
EnrollmentDate

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
Top