Hello, my problem is that i want to create an appending query that will transfer data from one horribly designed table to many other tables. tables are listed as follow. bad table!! and the data source tblMSM fields: ID | ModelNumber | Spring | Border | Quilt1 | Quilt2 | Quilt3 sample record 01 A33000M S01 B01 Q01 Q02 Q03

Hey Sprinks; thanks for understanding man. now the big bad table looks like this: BED Field fieldtype ------------------------------------------ ID AutoNumber(Primary Key) ModelNum text Desc1 text Desc2 text Desc3 text Spring text pattern

On Fri, 23 Feb 2007 08:46:13 -0800, Will G <bigwillno2@yahoo.com> wrote: yes John, my table looks like this: bedID quilt1 quilt2 quilt3 spring uphfill1 uphfill2 uphfill3 uphfill3 and this table was originally made before i started working with this database and i am trying to correct couple of the problems that it has. the data is redundant and i like to create one table for each

Will, Make a backup copy of your current database and create the master tables for the quilts and uph's. I assume you already have master tables for the two items similar to: Quilts -------------------- QuiltID Text to accommodate existing code (PK) ...other quilt-specific fields Uph -------------------- UphID Text (PK) ...other Uph-specific fields

Hey i know this might not sound smart, but i am working with a database where initially the tables were or design horribly wrong. The tables have multiple like fields and now they have a huge amount of record in them. now, the person that design this tables have no idea on how to do create a database and i am new to this as well. however, i know that it's no correct to create tables like