[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
>
>