autonumber

[SHETTY]

Dear Friends

I have got 2 sub table with autonumbers -both are primey keys
There may be problem while consolidating data of 2 tables in querry

So I want to start autonumner of 2nd table from 5000
is it is possible

please help me

ramesh shetty

 

[scubadiver]

I think an easier thing to do would be to treat the field as integer, enter
5000 into the first record and then increment by one for each record.

 

[scubadiver]

Found this in another thread:

One easy way is to use the Form's BeforeInsert event:

Private Sub Form_BeforeInsert(Cancel as Integer)
Me!ID = DMax("[ID]", "[YourTableName]") + 1
Me.Dirty = False ' force a save of the record to disk
End Sub

 

[Michael Gramelspacher]

Found this in another thread:

One easy way is to use the Form's BeforeInsert event:

Private Sub Form_BeforeInsert(Cancel as Integer)
Me!ID = DMax("[ID]", "[YourTableName]") + 1
Me.Dirty = False ' force a save of the record to disk
End Sub

Dear Friends

I have got 2 sub table with autonumbers -both are primey keys
There may be problem while consolidating data of 2 tables in querry

So I want to start autonumner of 2nd table from 5000
is it is possible

please help me

ramesh shetty

Seems to me that trying to force a save may not work if any fields are
designated not null.