automated answers

[Guest]

I've been looking throughout the forum and the help database, but I'd rather
have someone elses help (in lamens)!
I'm trying to create a database requiring lot's of names and dates and
times! I've got the automatic date/time stamp down...when putting a certain
name in a field I need it correspond to another field that would populate
another name (i.e. a number of students to one teacher). Thank you for your
help!

 

[John Vinson]

I've been looking throughout the forum and the help database, but I'd rather
have someone elses help (in lamens)!
I'm trying to create a database requiring lot's of names and dates and
times! I've got the automatic date/time stamp down...when putting a certain
name in a field I need it correspond to another field that would populate
another name (i.e. a number of students to one teacher). Thank you for your
help!

That doesn't give us any clear view of the nature of your data.

See the links at

http://home.bendbroadband.com/conradsystems/accessjunkie/resources.html#DatabaseDesign101

for an introduction. You will need to identify the "Entities" - real
life persons, things, or events; each type of entity (Teachers,
Students, Events...) would correspond to a Table. Just FWIW, the
Students table should emphatically NOT contain the teacher's name, or
vice versa - just links to the related table or tables.

John W. Vinson[MVP]