Two autonumber fields using subforms

[Guest]

I am creating a database for podiatry (medical) treatment. Wanting an invoice
(autonumber) that will accept multiple treatments( ie Rest homes are invoiced
for many patients). These treatments also need a unique ID number
(autonumber).
I have designed an Invoice table with two fields (Invoice Number (Auto) and
Treatment Number.). A Treatment table Has four fields. - Treatment number
(auto) / Leftor right foot / treatment site / procedure.
I have been using subforms and playing with event procedures to try and
input the treatment number in the invouce table..
Im slowly getting into recordsets and VBA if that is the way to go.
In summary how do I get the two autonumber fields to operate?
Thanks for any help.

 

[RuralGuy]

I am creating a database for podiatry (medical) treatment. Wanting an invoice
(autonumber) that will accept multiple treatments( ie Rest homes are invoiced
for many patients). These treatments also need a unique ID number
(autonumber).
I have designed an Invoice table with two fields (Invoice Number (Auto) and
Treatment Number.). A Treatment table Has four fields. - Treatment number
(auto) / Leftor right foot / treatment site / procedure.
I have been using subforms and playing with event procedures to try and
input the treatment number in the invouce table..
Im slowly getting into recordsets and VBA if that is the way to go.
In summary how do I get the two autonumber fields to operate?
Thanks for any help.

Invoice numbers usually *must* be in an unbroken sequence. An AutoNumber field
does *not* guarantee that condition so I would recommend not using an AutoNumber
for that function. Do your own Invoice number using Dmax in the BeforeUpdate
event of your form.
_______________________________________________
hth - RuralGuy (RG for short)
Please post to the NewsGroup so all may benefit.