Select to view content in your preferred language

Sequential Numbering of Labels Dynamically?

495
0
05-02-2011 07:49 AM
StephenBenzek
Emerging Contributor
I want to have the points numbered sequentially with a "keyed" table of information on each point.  The numbers are not known in advace---its based on a user query.  THis is like the web site of a hotel chain or Yelp that shows locations numbered on a map with a table below of addresses and descriptions.

I want the numbering to by dynamic, but predictable.  This VB label function numbers them sequentially, but I have no idea about the order:
Label expression:
Public KeyNumber
FUnction FindLabel([ProjectID])
KeyNumber = KeyNumber + 1
FIndLabel = KeyNumber
End Function

Since I do a separate DB query to get the table of values, I need to know the numbers that are assigned and know their order.

Any suggestions will be greatly appreciated!
0 Kudos
0 Replies