>>>To digress just a bit, I have always had a philosophical hang up with using numeric type fields for essentially non-numeric data?
>>
>>(Just from experience) That is a good philosophy, character fields are faster than numerics. I think Integer is faster than them both though, and thats what you shuld use as your PKs or FKs.
>
>Gracias to you and Andrew. It still bugs me though. :)
Once you start [if not already] using parameterized views [local and/or remote], you will be mighty grateful that you use meaningless, integer key fields.
Mark McCasland
Midlothian, TX USA