[thelist] ColdFusion and Access - auto-ID update..??
Judah McAuley
judah at alphashop.com
Mon May 7 18:51:43 CDT 2001
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>
More information about the thelist
mailing list