Auto numbering of new records

[edwardcga]

I am creating an application for recording offerings in a church. My Table structure are:
OFFERING HEADER TABLE
OFF_ID
DATE

OFFERING_DETAIL
OFF_ID
ENV_NO (text field "M001")
GEN_AMT
BLDG_AMT
OTHERS_AMT
TOT_AMT (CALCULATED FIELD)

I would like to build a form for entering date (OFFERING_HEADER and subform OFFERING_DETAIL)
USER create a new offering_ID and enter all offerings by each envelope received.



I would like to have the ENV_NO auto advanced by 1, the format is 1 CHARACTER "M" for cash, "Q" for chq. How can I accomplish this.

Thanks

R

[ssanfu]

Consider this structure:

OFFERING_HEADER
-------------------
OFF_ID_PK (Autonumber)
OFF_DATE


OFFERING_DETAIL
-----------------
OFFDET_PK (Autonumber)
OFF_ID_FK  (link (foreign key) to table OFFERING_HEADER)
ENV_NO (text field "M001")
GEN_AMT
BLDG_AMT
OTHERS_AMT
TOT_AMT  (CALCULATED FIELD)

"Date" is a reserved word in Access and shouldn't be used as object name.
"TOT_AMT" - Calculated fields generally should not be saved in a table because it can be calculated when necessary.

I would like to have the ENV_NO auto advanced by 1, the format is 1 CHARACTER "M" for cash, "Q" for chq. How can I accomplish this.

See
http://baldyweb.com/CustomAutonumber.htm
http://www.vbforums.com/showthread.p...-autonumbering
http://www.bigresource.com/VB-Access...tml#rIbrSkTZWZ