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