Database Design

[Guest]

When I went to enter a new record a message popped up saying that this
couldn't be done because a related record was required in my 'Preschool'
Table.
I thus far only have two tables. My main and my 'Preschool'. My primary key
in preschool is autonumber to a number field in my main table. My only other
field is the list of preschools. Somewhere I did something wrong.

 

[Guest]

A couple of things I think.
In a one-to-many relationship you have a primary key in the 'one' table to a
foreign key in the 'many' table. An Autonumber field is always a unique
number and would always be a 'one' side of any relations.

Your Preschool would be the 'one' side and can have the autonumber field.

I am assuming what you call your 'main' was to list students which would be
the 'many' side.

Unless your 'main' was the District with Preschool as the 'many' side.

Use the autonumber on the 'one' side and number - integer on the 'many' side.