Master table: GrantInformationsee the attachment for the relationship
Grant Index Autonumber PK
Activity Code text
Status text
Likewise 35 more fields
Child table: tblProjectDeliverables
DeliverableId Autonumber Not Indexed PK
Grant Index Number Indexed Required PK
Table: tblDeliverables
DeliverableId Number Required
PerformanceMeasure Text
ChkboxValue Yes/No
TextboxValue number
GoalValue number
Conditions:
1)One GrantIndex can have multiple Deliverables
2)one Deliverable is made from combination of more than 85 performance measures.
Performance measures have chkbox value, textbox value (number) and goal value(number)
My question:
My main form has several tabs. One of them is Project Deliverables.
When I click on that tab,
1) I want a subform to be opened for data entry to tblDeliverables.(bound to tblDeliverables where user can select yes/no option and enter the actual number with consideration of goal number)
2)At the same time the DeliverableId from tblProjectDeliverables table should also be increased automatically and reflect on the subform bound to tblDeliverables.
What I have done!!
I have subform bound to tblProjectDeliverables within main form bound to Grant Information table. There is a subform bound to tblDeliverables withing the subform bound to tblProjectDeliverables.
Basically it is subform within the subform .
GrantIndex number is automatically populated in table tblProjectDeliverables but the DeliverableId field is not automatically incremented although it is a autonumber field.
Let me know if you want any further clarification. Please help me on this. PLEASE!!