Connect a table to another using FK UNIQUE
Posted on 2010-08-24
I have two tables, one is STORE and the other is BLOCK. I have blocks within stores.
I had to update the UNIQUE key in the STORE table so it includes:
countryCode, cityCode, storeCode, vendorCode, storeType, classCode - classCode being the new part of the UNIQUE key.
My other table, BLOCK, connects to this as a FOREIGN KEY but got disconnected when I included classCode in the STORE table.
I still need this link to be there but when I try to reconnect BLOCK to STORE it says I have to have classCode in the BLOCK table. I really don't need that in that table so I'm lost as to what to do?
Any help would be much appreciated.