At 08:19 PM 7/20/2001 +0200, Nico Callewaert wrote:

> The problem is : for some articles , there is no article number. Now, I
> guess I have to use a surrogate key, with numbers generated by a
> generator. Isn't that a little bit wasted space ? That field doesn't
> have really a meaning, but I think it's the only way do do it ?

Not only is it the only way to do it, it's probably the best way as well.
Yes, you'll be storing 8 extra bytes per record, but consider the value of
your sanity...


Regards,

Ann
www.ibphoenix.com
We have answers.