Terri Jarus
jarus at amerinet-gpo.com
Wed May 14 06:07:48 CDT 2003
I wouldn't think you would need to do a join. Just set up an append query using Table 2 only - when you run it, Table 1 will only accept those records that have a unique PK. >>> Alun.Garraway at otto.de 05/14/03 04:40AM >>> if the LINK_PT is null you want to append the new records, right(?) if that's the case, you set the LINK_PT as PK no duplicates allowed, then the append qry can only add records that are new. hth alun -----Ursprüngliche Nachricht----- Von: Selina Iddon [mailto:selina at easydatabases.com.au] Gesendet: Mittwoch, 14. Mai 2003 02:04 An: accessd at databaseadvisors.com Betreff: Re: [AccessD] Quick Update Solution How would you go using an append query with a one-way join on the tables (the one with the records and the receiving table) and criteria where the LINK_PT is null in the receiving table. Cheers Selina > > >>> pblack at hotmail.com 05/12/03 02:38PM >>> > Is there a quicker/better way to append data than the method I > currently > use: > > select all records from table 1 > > move to first record in table 1 > > loop through every record in table 2 to see if a match occurs on > LINK_PT > field > > If there is a match it is skipped. > > If there is no match then table 1 record is appended to table 2 > > Move to next record in table 1 and continue loop until .eof > > I can do it this way but is there another quicker solution. As the > tables > grow the speed slows. I am using A97 for the app. > > Thanks > > Paul > > _________________________________________________________________ > The new MSN 8: advanced junk mail protection and 2 months FREE* > http://join.msn.com/?page=features/junkmail > > _______________________________________________ > AccessD mailing list > AccessD at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/accessd > Website: http://www.databaseadvisors.com > _______________________________________________ > AccessD mailing list > AccessD at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/accessd > Website: http://www.databaseadvisors.com > > _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com