On Wednesday March 19 2003 9:18, [EMAIL PROTECTED] wrote:
>
> What I want to be able to do is make sure that at all times the child
> records linked to a parent record have values for the "rank" field that
> are consecutive starting at 1, ie (1,2,4,5,6) not (1,2,4,5,7).
>
> Can someone offer the be
hello,
I was hoping someone might be able to help me with this problem...
I have a table that is essentially joined back to a parent table. I have a
column in the child table called "rank" that is a simple integer data type, used
to indicate the order that the child elements should be displayed
