Look up

[benitezm]

Hi guys, I'm in the Army and I try to set up a database for my compan about
personnal stuff. Well one of my question is I have a have 3 different table
one pushups, second situps and the third one 2 mile run. Well I have a form
with a subform. In the main form I have three fields that I enter the score
that the soldier achived. I'm trying to get the points after enter the raw
score. I'm trying to used the subform as a reference.

 

[John Vinson]

Hi guys, I'm in the Army and I try to set up a database for my compan about
personnal stuff. Well one of my question is I have a have 3 different table
one pushups, second situps and the third one 2 mile run.

Why three tables, rather than one table with a field to indicate which
exercise?

Well I have a form
with a subform. In the main form I have three fields that I enter the score
that the soldier achived. I'm trying to get the points after enter the raw
score. I'm trying to used the subform as a reference.

How do the "points" relate to the "raw score"? Where are you trying to
enter the points? WHat is the Recordsource of the mainform, and the
subform? What sort of "reference"?

Remember - YOU can see your database, and know its structure. We
cannot!

John W. Vinson[MVP]