RecordSource problem

  • Thread starter Thread starter Bob
  • Start date Start date
B

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
 
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
 
Back
Top