Part 1.
I have a main table (obviously) Which has several fields which are populated from a combo box on a form.
Each of these combo boxes take their values from a table, also stored in this table is a score for each of the values. I need to get these values and create a total score for each entry in the main table.
Part 2.
I also need to get a score from the sub table, however i only need this to be based on if there is an entry or not. If the Main Table enrty has NO entries in the sub table i want the score to be 10. This is then to be added to the Main Table entry's total score.
Part 3.
I think part of the problem is that the database isn't "normalised", How do i do this? I think my forms need to send the ID of each of the enties rater than the text? But how will i do a querry then?
A colegue has left this database for me to finish, so i'm not sure what i'm doing!
Download sample database from here....
Bee
temp, thrown in at the deep-end....again!
I have a main table (obviously) Which has several fields which are populated from a combo box on a form.
Each of these combo boxes take their values from a table, also stored in this table is a score for each of the values. I need to get these values and create a total score for each entry in the main table.
Part 2.
I also need to get a score from the sub table, however i only need this to be based on if there is an entry or not. If the Main Table enrty has NO entries in the sub table i want the score to be 10. This is then to be added to the Main Table entry's total score.
Part 3.
I think part of the problem is that the database isn't "normalised", How do i do this? I think my forms need to send the ID of each of the enties rater than the text? But how will i do a querry then?
A colegue has left this database for me to finish, so i'm not sure what i'm doing!
Download sample database from here....
Bee
temp, thrown in at the deep-end....again!
