Connecting Tech Pros Worldwide Help | Site Map

There is supposed to be only one table . . .

Sami
Guest
 
Posts: n/a
#1: Nov 12 '05
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
Guest
 
Posts: n/a
#2: Nov 12 '05

re: There is supposed to be only one table . . .


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:pbfm00pp7oi2s39ujbe78k6oqhgc5bsvej@4ax.com...[color=blue]
> 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.[/color]


Robert
Guest
 
Posts: n/a
#3: Nov 12 '05

re: There is supposed to be only one table . . .


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

Robert
robertharvey@nospam-unforgettable.com

<Sami> wrote in message news:pbfm00pp7oi2s39ujbe78k6oqhgc5bsvej@4ax.com...[color=blue]
> 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.[/color]


Closed Thread