table updates

[Roy]

Hi,
I have a A2000 application.I use a form with few subforms to update
tables.recently two new tables were added.Since the space on the main
form was filled and already few subforms were in use,I designed a popup
form with a master and child forms to accomodate the new table
updates.The Main form is related to the pop up form(master) with the
EvevID key.The master and child forms in the pop up are related by a
TbID key.The EvevID is a Autonumber field on the Main table.Also the
TbID is another Autonumber field.
When I try to add a new row in the pop up form,it comes with a error
related field not found in the main table.
Any help?Or should I design differently?

Roy

 

[Allen Browne]

A common solution for this is to put a tab control on your form.

In the first page of the tab control, put all the fields that belong to the
main table. In the subsequent pages, put your subforms.

That's going to be simpler than trying to use the BeforeInsert event of the
popup form to read the value of the primary key from the previous form and
assign it to the foreign key field in the popup.