Hi
Rather than posting in an old thread I thought I'd start this one, but basically what I need to do is outlined here:
http://www.thescripts.com/forum/thre...e+foreign.html
I am having trouble creating the surrogate key mentioned in that post; obviously it has to be autoincrementing, but I get the error "1075 - incorrect table definition; there can only be one auto column and it must be defined as a key".
This makes no sense really as the surrogate key column does not need to be a PK, that's the whole point -- it's acting as a surrogate for the combination of two other columns which actually are the PK (composite).
What do I need to do here?
-NickZA