By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,963 Members | 1,751 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,963 IT Pros & Developers. It's quick & easy.

There is supposed to be only one table . . .

P: n/a
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.
Nov 12 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
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.

Nov 12 '05 #2

P: n/a
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.

Nov 12 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.