J
John Petty
I have a form that is derived from an action query (qyfeadata). This query is
created using two separate table (tblWheelData, tblFProj). The form works
great for updating records and adding new Records, but I need to add a "New
Iteration" capability.
When adding a new record, the form populates both the tblWheelData and
tblFProj tables (via the action query). For the "New Iteration", I need to
use the forms format (visual) and just create the new record in the tblFProj
table (and the query of course). In the tblFProj table, I use the
WheelNameID (from the tblWheeldata table) as a foreign key to link the two
tables.
The question is (I think), once I populate the subform with the data from
the action query, how can I save the record to only the tblFProj without it
trying to add a new record to the tblWheeldata at the same time?
created using two separate table (tblWheelData, tblFProj). The form works
great for updating records and adding new Records, but I need to add a "New
Iteration" capability.
When adding a new record, the form populates both the tblWheelData and
tblFProj tables (via the action query). For the "New Iteration", I need to
use the forms format (visual) and just create the new record in the tblFProj
table (and the query of course). In the tblFProj table, I use the
WheelNameID (from the tblWheeldata table) as a foreign key to link the two
tables.
The question is (I think), once I populate the subform with the data from
the action query, how can I save the record to only the tblFProj without it
trying to add a new record to the tblWheeldata at the same time?