graybeardtx - Tuesday, December 13, 2011 2:49 PM:
I'm having one of those moments... using the "alternate demo database" trying to alter the sequence numbering for creating new Part item type. In the ItemType, item_number is defined simply as a string of length 32. There doesn't appear to be a secondary view with the item_number being defined as a sequence.
When I create a new part and assign the "Part Number" using the sequence arrows, it uses the sequence defined as "Default Part". Where is this relationship created?
eric_h - Tuesday, December 13, 2011 6:27 PM:
You need to define (or alter an existing) Sequence, which can be done under the Admin folder in the TOC (tree structure in the left.) Then, in the Part item type you can alter the 'item_number' property so that the Data Source is Sequence, and you can set the Data Source to the newly created sequence you created:
graybeardtx - Tuesday, December 13, 2011 9:06 PM:
Thanks for the response. I understand the process for associating a sequence with a property of an item_type. What confuses me is the fact that there is no apparent association between the Sequence "Default Part" and the property item_number. There must be an association somewhere else and that is what I am trying to discern. This appears to be something "New" as it only appears in the "alternate data base"
eric_h - Wednesday, December 14, 2011 12:10 PM:
Sorry, guess I misunderstood. I have not used the Demo database. The default installation database does not have a 'Default Part' sequence defined, so I cannot try and track where it is used. FWIW, a sequence could be defined (i.e. listed in the grid for Sequences) and not actually be used anywhere.
I just tried to used the 'where used' and 'structure browser' on a sequence that we have associated with a property, and it doesn't show that it is being used (probably because this isn't a normal Item --> Relationships --> Item relation). Not sure the best way to track where it might be used.
graybeardtx - Wednesday, December 14, 2011 12:39 PM:
No problem. I did manage to discover how it is done.
On the Form, when editing you can add an HTML item then in the Field Type they put in HTML code that does the sequencing. Pretty neat.
