F
Fysh
I have been at this for a few days and it seems like I am going in circles,
hopefully someone here has a solution. Anyway I using Access 2k. I have a
subform with a query as the record source. The query is drawn from several
tables. One of these tables is my main problem. The table is setup as
follows:
tblPracticalResults
PracticalResultsID PK
PracticalID FK
Attribute number
AttributeDetail number
Anomaly number
AnomalyDetail number
PoinstPossible1
PoinstPossible2
PointsStudent1
PointsStudent2
etc.
Anyway I have another form which after selecting the students and their
information, runs some append queries to populate this table. I can have
either 1 or or 2 students which will be evaluated at the same time.
Back to the subform. This subform is a continuous form which has a textbox
for the Attribute, 2 hidden text boxes for PointsPossible, and 2 combo boxes
for PointsStudent1 and PointsStudent2. The combo boxes use a query based on
the values in the 2 text boxes. What I am trying to do and would like to do
is for every attribute or anomaly populate the attribute textbox and have the
corrsponding combo boxes match that particular item. I tried using a union,
but my combo boxes won't allow me to update the table. I tried using
unbound, but then once you update one all get the same number. I even tried
to place both attribute and anomaly in the same column, however I only get
the number of the item and can't get the actual text (from the query I can
use the actual name from the relationship).
So does anyone have a solution for my problem? Should I actually put text
in the attribute column which match the attribute or anomaly. This would
work, but doesn't seem to be the best solution since one test could have up
to 100 records and the database could get huge.
Thanks for any replies
hopefully someone here has a solution. Anyway I using Access 2k. I have a
subform with a query as the record source. The query is drawn from several
tables. One of these tables is my main problem. The table is setup as
follows:
tblPracticalResults
PracticalResultsID PK
PracticalID FK
Attribute number
AttributeDetail number
Anomaly number
AnomalyDetail number
PoinstPossible1
PoinstPossible2
PointsStudent1
PointsStudent2
etc.
Anyway I have another form which after selecting the students and their
information, runs some append queries to populate this table. I can have
either 1 or or 2 students which will be evaluated at the same time.
Back to the subform. This subform is a continuous form which has a textbox
for the Attribute, 2 hidden text boxes for PointsPossible, and 2 combo boxes
for PointsStudent1 and PointsStudent2. The combo boxes use a query based on
the values in the 2 text boxes. What I am trying to do and would like to do
is for every attribute or anomaly populate the attribute textbox and have the
corrsponding combo boxes match that particular item. I tried using a union,
but my combo boxes won't allow me to update the table. I tried using
unbound, but then once you update one all get the same number. I even tried
to place both attribute and anomaly in the same column, however I only get
the number of the item and can't get the actual text (from the query I can
use the actual name from the relationship).
So does anyone have a solution for my problem? Should I actually put text
in the attribute column which match the attribute or anomaly. This would
work, but doesn't seem to be the best solution since one test could have up
to 100 records and the database could get huge.
Thanks for any replies