RecordSource problem

[Bob]

I have two tables, staff and staff_data. They are joined
on field staff_id on a one-to-many basis.

I have a query based on the two tables which is a
RecordSource for a form. When I open the form in
DataEntry mode and begin inputting, a record is added
automatically to the staff table. How can I make sure a
record is also added to the staff_data table ?

Thanks

 

[dan artuso]

Hi,
In general you handle this with a form/subform using your
staff_id field as your link. Your main form would be based on the staff table
and the subform on the staff_data table