I wonder whether someone might be able to help me with the following, please.
In my Access database, I have two tables that are related to each other. tblReferences holds data on various potential reference information which may relate to my projects.
tblReferences : ReferenceID [primary key], Details
tblProjects : ProjectID [primary key], ReferenceID, ......and some other fields realting to my projects.
I've set up a one-to-many relationship between tblProjects and tbleReferences (ie each Project can have multiple references, one reference, or no references), with referential integrity.
I already have a few hundred records in tblReferences. And I have a couple of hundred project records. I'm trying to now link the relevant references records to the relevent Projects, via a subform, but am having problems. I've tried an unbound combo-box (with the data source being a query including ReferenceID and Details) in the subform, and - based on my selction in the combo-box, tried to populate ReferenceID and Details fields in the subform. With my latest attempts, I'm getting an errror-message telling me that I can't create a subform record in that way because it'll create duplicate records.
Can anyone help with this ?
In my Access database, I have two tables that are related to each other. tblReferences holds data on various potential reference information which may relate to my projects.
tblReferences : ReferenceID [primary key], Details
tblProjects : ProjectID [primary key], ReferenceID, ......and some other fields realting to my projects.
I've set up a one-to-many relationship between tblProjects and tbleReferences (ie each Project can have multiple references, one reference, or no references), with referential integrity.
I already have a few hundred records in tblReferences. And I have a couple of hundred project records. I'm trying to now link the relevant references records to the relevent Projects, via a subform, but am having problems. I've tried an unbound combo-box (with the data source being a query including ReferenceID and Details) in the subform, and - based on my selction in the combo-box, tried to populate ReferenceID and Details fields in the subform. With my latest attempts, I'm getting an errror-message telling me that I can't create a subform record in that way because it'll create duplicate records.
Can anyone help with this ?