By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
425,940 Members | 611 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 425,940 IT Pros & Developers. It's quick & easy.

Auto number field is not working

jinalpatel
P: 68
I am dealing with 3 tables. Here is a brief meta data
Master table: GrantInformation
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
see the attachment for the relationship

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!!
Feb 17 '09 #1
Share this Question
Share on Google+
1 Reply


NeoPa
Expert Mod 15k+
P: 31,419
There is no question here.

You simply state (as your two questions) what you want.

What is the question?
Feb 18 '09 #2

Post your reply

Sign in to post your reply or Sign up for a free account.