Use a number field as ID

[696796]

Good morning tippers,

Ok, here is the scenario :-

I use a table (tblIssue) which has these fields -

issueID
issueDescription
problemNo

issueID is an autonumber which is just an id to link to an issueOccurance table. I would like the field problemNo to update itself every time a record is added.

issueID - 1
issueDesc - problem with psu
problemNo - 2094

then i add the next record, and problemNo is 2095

Get what i mean?

Do i need an update/insert query? how do i implement this?

Thanks for any help,

Alex

 

[PHV]

Take a look at the DMax function you can play with in the BeforeInsert event procedure of the form.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244