auto number

[Zee16]

Hi can someone please assist

i need to create a autonumber for my project activities where by if the project number is 1 then my activities must start from 1.1 and increment likewise if its project is 2 then my activity must start from 2.1

 

[michaeljryan78]

The Activity ID would not be an autoNumber field. It would be a number and it would have to allow duplicates. The Activity table may have to have a composite key of ProjectID and ActivityID.

If this is just for display, then you cn concatenate the 2 keys together in a query. FullProjectID: ProjectID & "." & ActivityID

 

[Cronk]

The autonumber field is a long integer and cannot hold decimals.

What is the next value after say 2.9? Is that 2.10? In which case, should the first occurence be 2.01, or maybe 2.001?

In a sort, 2.10 would come before 2.9