[AccessD] Create Junction Table From Existing Data

Mitsules, Mark S. (Newport News) Mark.Mitsules at ngc.com
Tue Apr 20 15:23:11 CDT 2004


Group,

Is there a method to create a junction table from a non-normalized table?  I
inherited a table that I now need to normalize into two primary tables and a
joining junction table.  The primary tables were easy enough to create, but
how can I create the junction table?

I want to take a records such as:
Fld1	Fld2 	Fld3 	Fld4 	Fld5	<=Fields
Dat1	Fld2 		Fld4 	Fld5	<=Record
Dat2		Fld3	Fld4		<=Record

And turn it into:
Fld1	FldID	<=Fields
Dat1	Fld2	<=Record
Dat1	Fld4	<=Record
Dat1	Fld5	<=Record
Dat2	Fld3	<=Record
Dat2	Fld4	<=Record


Mark



More information about the AccessD mailing list