[AccessD] Create Junction Table From Existing Data

On 20 Apr 2004 at 17:08, Mitsules, Mark S. (Newport Ne wrote:

> I did just that to create the primary tables.  But, since I've never had to
> do this on such a grand scale, I need assistance in generating the junction
> table.  Here is pseudo data for clarification.  I've placed dashes to
> maintain alignment.
> 
> ID--CODE--SA--SAR--SRD
> 1---EA1---SA--SAR--SRD
> 2---EEY1--SA
> 3---EEY2--SA--SAR--SRD
> 
> ...from the data above, I need:
> PK--CODE--TYPE
> 1---EA1---SA
> 2---EA1---SAR
> 3---EA1---SRD
> 4---EEY1--SA
> 5---EEY2--SA
> 6---EEY2--SAR
> 7---EEY2--SRD
> 
> Any suggestions?
> 

I'd do it in code.
Open the old data set and step through it.
For each record, step through the fields and create a new record in 
the new table where required.

 
-- 
Lexacorp Ltd
http://www.lexacorp.com.pg
Information Technology Consultancy, Software Development,System 
Support.