Calculate "score" from table drop downs and sub table entries

[nerdgnome]

I need help to calculate a "score" It's a bit complicated so bear with me!!!

I have a main table, in which the user select items from various drop downs populated by tables.

Each drop down is from a table contining it's ID, Name and Score.

I need to add all the scores for all the drop downs selected in the main table.

I have a sub table set up the same way, and also need to add these scores. For each main table entry there are multiple sub table entries.

I want to be able to save these values in a 3rd table so i can search for score ranges (egg 10-40).

Bee
temp, thrown in at the deep-end....again!

 

[lespaul]

I have a main table, in which the user select items from various drop downs populated by tables.

Do you really have tables with lookup fields? Are you really doing this in tables?

You should read The Evils of Lookup Fields in Tables
and consider doing all this in forms.

If you really want some help calculating this score, please provide the table names, the field names, some sample raw data and what you want your final results to be from the samples.


Leslie

In times of universal deceit, telling the truth will be a revolutionary act. - George Orwell

 

[nerdgnome]

*Confused*

I was told i needed to do this in tables to "normalise" the database!!

How to you do it from forms anyway?

Not got the database with me at the mo (it's at work). But i'll post the tables etc, tomorrow.




Bee
temp, thrown in at the deep-end....again!

 

[lespaul]

normalization doesn't have anything to do with using lookup fields in the tables. Have you read The Fundamentals of Relational Database Design? It explains the basics normalization.

Post back when you have the tables and stuff!

les