Make Table

M

MitziUK

I have 3 tables - 1 for vans/cars, 1 for lorries, 1 for plant. In all 3 of
these tables i have the fields 'make' and 'model'.....Doh (guess this idiot
designed the database incorrectly).

What I now want is to have just 1 table for 'make' and 1 table for 'model'.
I know I have to use a make table query, but I probably getting mixed up goes
I show all 3 tables in the query design view. Where am I going wrong please?

Thanks
 
J

John Vinson

I have 3 tables - 1 for vans/cars, 1 for lorries, 1 for plant. In all 3 of
these tables i have the fields 'make' and 'model'.....Doh (guess this idiot
designed the database incorrectly).

What I now want is to have just 1 table for 'make' and 1 table for 'model'.
I know I have to use a make table query, but I probably getting mixed up goes
I show all 3 tables in the query design view. Where am I going wrong please?

Thanks
Click to expand...

I'd suggest a different approach. Create the Make and Model tables in
the design window; either use Make and Model respectively as the
Primary Key, or at least put a unique Index on the Make in the Makes
table, and on the Model in the Models table.

Then run Append queries like

INSERT INTO Makes
SELECT DISTINCT Make
FROM [Vans/Cars];

INSERT INTO Makes
SELECT DISTINCT Make
FROM [Lorries];

etc.

rather than trying to do it all in one monster query.

John W. Vinson[MVP]
 
Top