A
APH
Here is what i have:
A form containing contact information and which is based on a query from
three tables - tblOrganisation, tblContact and tblSales. This query is not
updatable (for some reason of which I am not sure)
A subform, which is based on tblRequests and which is linked to
tblOrganisations above, through a field RecordId. This subform displays
partially completed records. I am able to update this subform records as I
require
I also have a second subform on the main form. This subform is based on a
simple query of tbl Notes, to order the records into date order, and is
linked to tblOrganisations again through field RecordId.
When I try to add a record to this second subform, I am getting a"must have
related records in tlb Organistions" error message. When I look at the
data, it is putting a zero into the Record Id field of tblNotes, and not the
Record Id data from tblOrganisations.
I am not quite sure why this is happening, and this second subform works
perfectly as a subform in another scenario.
Hope the above is clear, and would welcome any ideas
Thanks
Alex
A form containing contact information and which is based on a query from
three tables - tblOrganisation, tblContact and tblSales. This query is not
updatable (for some reason of which I am not sure)
A subform, which is based on tblRequests and which is linked to
tblOrganisations above, through a field RecordId. This subform displays
partially completed records. I am able to update this subform records as I
require
I also have a second subform on the main form. This subform is based on a
simple query of tbl Notes, to order the records into date order, and is
linked to tblOrganisations again through field RecordId.
When I try to add a record to this second subform, I am getting a"must have
related records in tlb Organistions" error message. When I look at the
data, it is putting a zero into the Record Id field of tblNotes, and not the
Record Id data from tblOrganisations.
I am not quite sure why this is happening, and this second subform works
perfectly as a subform in another scenario.
Hope the above is clear, and would welcome any ideas
Thanks
Alex