>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.
If I understand your problem correctly, you will still need to explicidly add records to the second table. It will require some code in a method. You can either select the second table and use the append command, or you can use the 'Insert Into' command to add records to a non selected work area.