Look up

  • Thread starter Thread starter benitezm
  • Start date Start date
B

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.
 
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.
Click to expand...

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.
Click to expand...

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]
 
Back
Top