add record filtered linked form

[Guest]

I have two forms

Staff information and bookings

they are linked (through using the Wizard) and I need to be able to add a
record to the bookings form and for it to be saved to the filtered record
(produced when the form is accessed from the Staff Information form).

Any help would be much appreciated.

 

[jahoobob via AccessMonster.com]

Can we assume that you are logging the bookings by the staff and that one
staff member can have many bookings.
If this assumption is correct, you should have a main form (Single) based on
Staff and a subform (Continuous) based on Bookings linked by the PK ID of
staff.

 

[Guest]

You are correct.
I am logging the bookings made by the staff and that one staff member can
have many bookings. I have the main form with the staff information and this
is linked (via the Form creation wizard) to the bookings form. Staff
information is Single and Bookings is Continuous. They are linked by Staff
ID (PK).

Everytime I try to insert a record into the Bookings table for say Staff ID
100; the record appears to be added. When I return to the form the record
has not been added to Staff ID record 100 but to staff ID 0 instead???

Please help me if you can xxx

 

[jahoobob via AccessMonster.com]

Check the properties of the subform and make sure that the Link fields are
filled in correctly.

You are correct.
I am logging the bookings made by the staff and that one staff member can
have many bookings. I have the main form with the staff information and this
is linked (via the Form creation wizard) to the bookings form. Staff
information is Single and Bookings is Continuous. They are linked by Staff
ID (PK).

Everytime I try to insert a record into the Bookings table for say Staff ID
100; the record appears to be added. When I return to the form the record
has not been added to Staff ID record 100 but to staff ID 0 instead???

Please help me if you can xxx

Can we assume that you are logging the bookings by the staff and that one
staff member can have many bookings.

[quoted text clipped - 11 lines]

 

[Beatrix J B]

Hi .. seems like we have similar problem ... anyway what if i want to put
another subform on the main form how do i link this to the other subform
without inserting the subform into another subform ... It kind of hard to
resize and format when you are inside a subform within a subform.

If I put both in main form ... my link field is limited to ones available in
the main form ..... what i want to link are to subforms shown in the main
form.

Thanks.

Check the properties of the subform and make sure that the Link fields are
filled in correctly.

You are correct.
I am logging the bookings made by the staff and that one staff member can
have many bookings. I have the main form with the staff information and
this
is linked (via the Form creation wizard) to the bookings form. Staff
information is Single and Bookings is Continuous. They are linked by
Staff
ID (PK).

Everytime I try to insert a record into the Bookings table for say Staff
ID
100; the record appears to be added. When I return to the form the record
has not been added to Staff ID record 100 but to staff ID 0 instead???

Please help me if you can xxx

Can we assume that you are logging the bookings by the staff and that
one
staff member can have many bookings.

[quoted text clipped - 11 lines]

Any help would be much appreciated.