making query or table

[Mike]

I want to make a query or table containing 3 fields.

Field 1 is a unit name
Field 2 is a color
Field 3 is a size.


Field 1 comes from a drop down menu that contains a list of all available
unit names (they are listed in a table of unit names)

field 2 and 3 come from a table that is named for the unit name.

now the issue is that no fields are linked/ID'ed. the db is a few years old
and the creator didn't have a grasp of Keys and such wen making the db.
otherwise this would be fairly easy.

but anyway the 3field table/query i'm creating is then going to be used to
get the over all lengths of each unique color/size combo in the unit name
table.

any thoughts?