Re: Move data between tables with INSERT-LOOP?

["newportri" <webforumsuser@xxxxxxxxxxxxxx>]

Ken & Dan:

 Thanks for all your help with this.

 I thought that might be why (vendor can have multiple addresses) but that's 
not the case here.

 I think the problem is that I'm not used to seeing 5 or 6 junction tables when 
1 or 2 would do- guess that makes me a "lumper".

 The DB itself is filled with double entries and other data input errors made 
over the last several years, ending up with junction tables with 70,000 
records, etc.- just am not prepared to re-invent the DB structure- will work 
around the issues.

 Thanks again-

 newportri