Help with table design to populate continuous subform.

F

Fysh

I am hoping someone can help me out on this. I seem stuck and going in
circles. I have a form with a continuous subform. When a student is
selected and the Category to be scored from the main form, it should populate
the subform with all of the person’s training requirements. The title of the
requirement goes into a textbox the points possible in a hidden text box and
the points scored in a combo box which uses a query based on the points
possible. When an Attribute has associated details then the Attribute is
highlighted and is turned into a hyperlink to open another continuous form
with all the associated details, the same goes for anomalies. Now the student
can have attributes, attributes with details, anomalies, and anomalies with
details. All of these are in separate tables and are placed into a table to
populate the subform and to have them scored.

Well anyway here is part of some of my tables.
tblAttribute
ATTID PK
Attribute
PracCatID FK
PointsPossible
Etc

tblAttributeDetail
AttributeDetailID PK
Detail
ATTID FK
PointsPossible
Etc

tblAnomalies
AnomalyID PK
Anomaly
PracCatID FK
PointsPossible
Etc

tblAnomalyDetail
AnomalyDetailID PK
Detail
AnomalyID FK
PointsPossible
Etc.

tblPracticalData
PracticalResultsID PK
PracticalID FK
PracCatID
ATTID FK
AttributeDetailID FK
AnomalyID FK
AnomalyDetailID FK
PointsScored
Etc.


Since the subform

My problem that I am running into is how can I populate the continuous
subform with the Attributes and Anomalies? For some reason I can only allow
one or the other to be populated. It should be like this on the subform.

Textbox hidden textbox combo box
Attribute points possible points scored
Anomaly points possible points scored
Attribute points possible points scored
Attribute points possible points scored
Anomaly points possible points scored


Am I doing this all wrong? Any help would be greatly appreciated.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top