G
Guest
I have a database containing two tables which are related through the Staff
ID number.
The first table Staff information is related with a 1:* relationship to the
bookings table.
I.e. one member of staff can book many courses.
I have created the forms based on these tables using the wizard provided in
Access 2003. Mid-way through the Wizard I used the option to LINK the forms.
When you open the Staff Information form you have a button which says
"Bookings". When you access the bookings form you are provided with a
listing of the courses the staff have booked onto.
My problem is that if I add any records to this bookings table they are
added; but to an incorrect staff record i.e. not the filtered record from the
staff Information table. How do I get added bookings to 1) Be retained 2) Be
retained within the filtered record already selected?
Please HELP!
Thanks for reading and sorry if this all seems a bit vague - not great with
terminology x
ID number.
The first table Staff information is related with a 1:* relationship to the
bookings table.
I.e. one member of staff can book many courses.
I have created the forms based on these tables using the wizard provided in
Access 2003. Mid-way through the Wizard I used the option to LINK the forms.
When you open the Staff Information form you have a button which says
"Bookings". When you access the bookings form you are provided with a
listing of the courses the staff have booked onto.
My problem is that if I add any records to this bookings table they are
added; but to an incorrect staff record i.e. not the filtered record from the
staff Information table. How do I get added bookings to 1) Be retained 2) Be
retained within the filtered record already selected?
Please HELP!
Thanks for reading and sorry if this all seems a bit vague - not great with
terminology x