I have re-ordered my tables (it has created the first few tables which require no foreign keys successfully)
Is it wrong to have a foreign key in my members type table called memberID and also to have the primary key in my members table called memberID. Could this be why it is not importing when I list the constraint like this…
CONSTRAINT member_fk FOREIGN KEY (`[B]member_id[/B]`) REFERENCES members (`[B]member_id[/B]`)
I’ve checked my relationships according to how you mentioned above and it is how you have described. What I’ve done is import tables (successful) without constraints. I am going to try and use ALTER table now and see if I can implement the constraints that way since the tables with fields are there now.