2 referential keys to one table

[JeroenV]

So i got own champion and enemy champion and they both are referencial keys to the table champion, is this correct? If i try to do edit the relationship i can't force referential integrity.

So is the way i do it now correct? It just seems odd the way it is now.

I hope it's clear enough, thanks in advance for the help.

 

[peregrin]

I'm not able to download files at present. But you must have primary keys in both tables to create referential integrity - that could be the issue. If you want to reply with a description of the fields in your tables I can respond with more direct advice.