[thelist] ColdFusion and Access - auto-ID update..??

[Judah McAuley]

Question:  If you delete item 3, do you want to also delete item 3.1 and 
3.2?  If not, do their ID's remain the same?  Or get moved to 3 and 3.1 
respectively?  That will have a big impact on how you code this.

Judah

At 04:34 PM 5/7/01 -0700, you wrote:
>Hello,
>
>I have a table with several records. Each has an id field, as well as
>other fields. The id can also be decimal, sort of like a 'sub id'.
>So...something like this:
>
>id    |   field1   |    field2
>  1    |      a     |       b
>  1.1  |      a1    |       b1
>  2    |      c     |       d
>  3    |      e     |       f
>  3.1  |      e1    |       f1
>  3.2  |      e2    |       f2
>  4    |      g     |       h
<snip>