Pangbiro
02-10-2002, 04:16 AM
right I've got a problom where i can't get the recordset to be updateable on my database.
What I am trying to do is to get a drop down box to update...
however the problem with this is that the querries won't let me do it.
I am trying to get information that is spread across three different tables to work together.
Table A holds names of people
Table B holds which group these people are in
Table C holds the score for each of these people each week.
Table B tells you which group the people are in by putting the persons personal number (from table A) next to the number of the group.
Table C has a date section so you can put in the date each week, (this is automattically done by an append querry each week) there is also the personal number from Table A, and a score section so u can input the relivant score.
And as mentioned Table A has the names of people and a personal score for each, and both the other two tables are related to this one by the Personal Number.
Now what I am trying to do is to select each person within they're group (from Table B) and be able to input their score only for that week.
What I have done so far is to select the groups of people in one querry, (this will be dependant upon a drop down menu on the form that this will work for.)
And in another querry I have selected the appropiate week. These both work fine, and I am left with two sets of personal numbers which I am trying to use to select only the people within a group and update their score.
Except whatever i try to do next it won't work. It comes up with recordset not updateable...
What I am trying to do is to get a drop down box to update...
however the problem with this is that the querries won't let me do it.
I am trying to get information that is spread across three different tables to work together.
Table A holds names of people
Table B holds which group these people are in
Table C holds the score for each of these people each week.
Table B tells you which group the people are in by putting the persons personal number (from table A) next to the number of the group.
Table C has a date section so you can put in the date each week, (this is automattically done by an append querry each week) there is also the personal number from Table A, and a score section so u can input the relivant score.
And as mentioned Table A has the names of people and a personal score for each, and both the other two tables are related to this one by the Personal Number.
Now what I am trying to do is to select each person within they're group (from Table B) and be able to input their score only for that week.
What I have done so far is to select the groups of people in one querry, (this will be dependant upon a drop down menu on the form that this will work for.)
And in another querry I have selected the appropiate week. These both work fine, and I am left with two sets of personal numbers which I am trying to use to select only the people within a group and update their score.
Except whatever i try to do next it won't work. It comes up with recordset not updateable...