Doug,

Thanks for your thoughts on the foreign key considerations. They
were a lot clearer than my thoughts!

I have removed the original post from ib-support because in re-
reading it I realized I had pretty much answered my own questions.
Not to mention that lunatic subject line. Also, having spent most of
the day switching back and forth between using short character codes
and integer keys, I realized I could have both if I wanted: use the
integer PK in some tables, short code in others. As long as the
right lookup method is used for each field, the results are the
same. But it throws consistency out the window, and that is a
lingering concern.

--- In ib-support@y..., Doug Chamberlin <DChamberlin@A...> wrote:
> Myself, I'd go with all surrogate values for all FK references. It
simply
> makes sense to me. This after over 20 years of trying all worts of
variations.

This is what I needed to hear! I have revised my schema about 15
times today, back and forth, back and forth. That's the ballgame
then. All surrogate keys.

So this gets to be fun at some point?? :-)

Regards,
Andrew Ferguson