Hi Bob.
You may make a local view for this form and then set update criteria to only field in 2nd table. You can add view data and it will add only in 2nd table only. However, I only used in browse window in append mode but never used in form before. But I believe that it should work the same as in browse window. Am I missing anything?
HTH
Sittipun Noiprasit

>I have created a mutli-table database. The two tables are related by location in a 1 to many relationship. The input form has 3 pages, and the last page deals with the 2ws table. Does anyone know how to add more records to the 2ed table only? All advise would be greatly aappreciated.
>thanks.