>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.
i think you need to ask the user which table they want to add info to. (probably two separate add buttons, one for each table). if they want to add to 2nd table, first select parent record (maybe preselect -- current record being viewed). when saving, make sure parent's unique key is referenced in secondary table to establish relationship.
did i miss anything?