making query or table

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?

.

Relevant Pages

  • Re: Selection criteria on parameter forms
    ... Work with the form first. ... The search form is bound to a table/query. ... The fields you wish to filter on need to be in that table/query. ... I can't even get the query to run properly, ...
    (microsoft.public.access.formscoding)
  • Re: query from two tables
    ... You need three joins between the "order" table and the other table/query. ... I have a query that will list all vendors from various ... The query works perfect for the information that I need. ... > am having difficulty 'matching' a single record with single record in ...
    (microsoft.public.access.queries)
  • Segmentation fault
    ... I have a script about query record from MS Access database. ... When I use the query command: select * from Lengths ... When I use the query command: select * from Lengths where Taxon_ID ...
    (perl.dbi.users)
  • Perl OBDC Segmentation fault
    ... I have a script about query record from MS Access database. ... When I use the query command: select * from Lengths ... When I use the query command: select * from Lengths where Taxon_ID ...
    (perl.beginners)
  • Perl OBDC Segmentation fault
    ... I have a script about query record from MS Access database. ... When I use the query command: select * from Lengths ... When I use the query command: select * from Lengths where Taxon_ID ...
    (perl.beginners)