Hi all,
I'm new to the Access world and to this site, so please forgive my lack of knowledge.
I currently have a form 'Project Data Entry' in which one enters project data - this form automatically generates a ProjectID.
The 'Project Data Entry' form includes a subform 'Tender Projects Data Entry' which consists of only a TenderProjectID (it's PK), and ProjectID (a FK relating to Projects) which is linked to the ProjectID in 'Project Data Entry'.
When I create a new Project in 'Project Data Entry', the ProjectID is automatically generated, and it appears in the 'Tender Projects Data Entry' subform. My problem is, once I enter this subform, I can't actually add anything to the Tender Projects table, since it doesn't automatically generate a TenderProjectID. Is there a way I can update the autonumber TenderProjectID so this subform creates a new entry and adds it to it's table?
Sorry if that was confusing, I can explain further if needed. Thanks.
I'm new to the Access world and to this site, so please forgive my lack of knowledge.
I currently have a form 'Project Data Entry' in which one enters project data - this form automatically generates a ProjectID.
The 'Project Data Entry' form includes a subform 'Tender Projects Data Entry' which consists of only a TenderProjectID (it's PK), and ProjectID (a FK relating to Projects) which is linked to the ProjectID in 'Project Data Entry'.
When I create a new Project in 'Project Data Entry', the ProjectID is automatically generated, and it appears in the 'Tender Projects Data Entry' subform. My problem is, once I enter this subform, I can't actually add anything to the Tender Projects table, since it doesn't automatically generate a TenderProjectID. Is there a way I can update the autonumber TenderProjectID so this subform creates a new entry and adds it to it's table?
Sorry if that was confusing, I can explain further if needed. Thanks.