> I don't like this design much because I don't like non-atomic indexes
> and I don't like hierarchical primary keys. But it's a different
> issue, I guess.

Well I'm always interested to learn something new.

In my case a SWIMRESULT record can have 0-n records in SPLIT
(intermediate times), but only one for a certain DISTANCE.

I always look at these split times as a collection of on SWIMRESULT at
the same time, a collection of pairs distance / swimtime.

So you think the tables/fields should look different? Or the indexes?
Or both?

cu Christian