There is supposed to be only one table . . .

[Sami]

I am working on a DB to track student athletes, and have created one
table only so far, even though I know it would be ideal to have more
than one, and thus not have a flat file.

However - what I did, until I can work out a few problems, is to
create a form, which has basic student information on it - name,
student ID number, etc., on it. This is all to be entered into the
only table.

From there, I used the TAB feature in Design View, so that I could
import forms I created for different information, all derived from the
same single table. Therefore, ideally, all information entered should
be contained in one row. However, I am finding I am getting two or
more rows at times, even if I am very careful NOT to enter something
more than once (since the subforms in the tabbed areas also have the
little 1, 2, 3, etc.).

What is wrong here?

Thanks!

PS - Novice at work! Please be very clear.

[MacDermott]

If you are using a single table, you should NOT use subforms on your Tab
Control.
Doing so will only slow your form down in loading.
Place your controls directly on each page.

HTH
- Turtle

<Sami> wrote in message news:pb********************************@4ax.com...

I am working on a DB to track student athletes, and have created one
table only so far, even though I know it would be ideal to have more
than one, and thus not have a flat file.

However - what I did, until I can work out a few problems, is to
create a form, which has basic student information on it - name,
student ID number, etc., on it. This is all to be entered into the
only table.

From there, I used the TAB feature in Design View, so that I could
import forms I created for different information, all derived from the
same single table. Therefore, ideally, all information entered should
be contained in one row. However, I am finding I am getting two or
more rows at times, even if I am very careful NOT to enter something
more than once (since the subforms in the tabbed areas also have the
little 1, 2, 3, etc.).

What is wrong here?

Thanks!

PS - Novice at work! Please be very clear.

[Robert]

Sami, can you send me a copy of your database? I can't figure out what you
are trying to do.

Robert
ro**********@nospam-unforgettable.com

<Sami> wrote in message news:pb********************************@4ax.com...

I am working on a DB to track student athletes, and have created one
table only so far, even though I know it would be ideal to have more
than one, and thus not have a flat file.

However - what I did, until I can work out a few problems, is to
create a form, which has basic student information on it - name,
student ID number, etc., on it. This is all to be entered into the
only table.

From there, I used the TAB feature in Design View, so that I could
import forms I created for different information, all derived from the
same single table. Therefore, ideally, all information entered should
be contained in one row. However, I am finding I am getting two or
more rows at times, even if I am very careful NOT to enter something
more than once (since the subforms in the tabbed areas also have the
little 1, 2, 3, etc.).

What is wrong here?

Thanks!

PS - Novice at work! Please be very clear.