Sequent number

[Vallan]

Hello.

I know this issue has been up here quit often.

Have tried to search for an answer and have come a bit forward to my solution.

But not all the way.

Here is my issue.....:

I would like to have a sequent ordering id but for 2 companies.

like this. company A has an ordering id by A1, A2, A3 etc.
likewise on company B....B1, B2, B3 etc.

I have managed to figure out how to make the sequent numbers. But would someone be kind to help me with adding the company?

The company name is in another tbl and conected by a combobox

The code i have so far is this.

Private Sub Form_BeforeInsert(Cancel As Integer)
Bokningsnummer = Nz(DMax("Bokningsnummer", "Nya_Sverige_huvudbokning_TBL")) + 1
End Sub

Would it in a easy way make an add with the companyname from the other table?

Sorrý if my english is bad and the eplanation is weird.


Hope someone understand anyway and woul like to give me some hints.

Matt

 

[pbaldy]

You need to add a criteria to the DMax to restrict it by company. More info on syntax here:

http://www.mvps.org/access/general/gen0018.htm