Hi,

I'd like to make a valuation of database records. Suppose you have a
table:

Name         Must have
Address      Should have
Zip          Should have
SocialSecNr  Must have
City         Should have
State        Should have
Salary       Must have
Carbrand     Would have
Kids_YN      Would have
Holiday_dest Would have

Now I want to give a number to every record, that gives me an idea how
far the data is supplied. The musthave-fields give me (say) 7 points,
shouldhave-fields 4 points, and wouldhave-fields 1 point.

So the following records gives me (maximum 40 points):

Name         Mark Johnson  --> 7 points
Address      123 Broadway  --> 4 points
Zip
SocialSecNr
City         NYC           --> 4 points
State
Salary
Carbrand
Kids_YN      YES           --> 1 points
Holiday_dest Norway        --> 1 points

17 points for this record.

This way, I can valuate the way our datacollection program is making
progress.

Does anyone has an idea how to implement this?

Thanks for any suggestions.