Forum Moderators: coopster
I've created a database with a number of tables. I've set up the all of the tables with primary keys, and a number of tables with foreign keys.
So far, so good.
But now, I want to actually create the "relationship" between the foreign keys and their related tables and don't know how to do it.
I'm using sqlYOG and help file indicates that before I can begin tying foreign keys to their related tables, I've first got to index certain fields, but it's not explicit enough for a complete beginner/bonehead like myself to know what I'm doing or exactly how to do that. And that, according to the help file, is just the first step.
I'm doing pretty well so far with this stuff (mostly with the help of the membership here) but I can feel myself slipping into deep water and need help with this topic.
Can anyone point me to a tutorial that will explain exactly what I need to do, and how to do it, to create these indexes and relationships? Please?
As always, thanks to all in advance!
Neophyte
That url looks like it'll do it for me. It's a lot to digest and I'll give you and update as to my success when I start applying the stuff they're talking about in my db.
Greatly appreciate the pointer.
Neophyte
