Multiple-value fields create blank database entries

If you are using views to create a view and have fields with multiple values, you will get duplicate entries in your views table, even after adding Node:Distinct to your view. As far as I know there is no way yet to combine them into one line, so that is something we have to live with for now.

However, there is something about the operation of cck that is making the problem worse, and it is fixable. If you select the option to allow multiple values for a field, but do not actually fill more than one value out for some records, cck is creating blanks fields for the empty entries. Then when you go to your view, you will see numerous multiple copies of each record, one for each of those values (even when the values are empty).

It seems like it would make more sense for cck not to create extra fields for empty multiple values. If it did not, it would at least make the problem less annoying, and it doesn't seem like there is any reason to create empty fields for some arbitrary number of additional fields (2 or 3 it looks like).