Rita, Thanks.
I began to do that but then hit a snag on how to handle the adults who are
students and students who are adults. Also, how to record adult students
who have children in a dance class. There are two right now. I want to
record mailing information only once and send it only to the parent or adult
student. I have to give it a lot more thought. I think I'm getting hung up
on calling it a parents table when it really is an adults table.

Could you or anyone direct me to a help site on this or a good book on table
design?
Nancy


"Rita Brasher" wrote in message
...
The parent table would be first. I'd assign a unique code to each parent,
then create a "Parent Code" field in the student's table to which I'd
link.

Just my thoughts...
Rita

Nan wrote:
Hi,
I'm trying to create a simple database for info for dance class students
that includes mailing addresses and class info. Most are children, so I
need the parent names. A few parents have two or three children in a
dance class. Some students are adults. I think I need a parents table
AND a students table otherwise I'm entering duplicate information
(addresses etc.)

Two students are also instructors but I think I can use a Yes.No field
for this. I can't get my head around how I link them.

What comes first, the parent table or the students table. Most are
children if that makes a difference.

Any help is appreciated.

Nancy