hi guys
im a total newbie when it comes to SQL and was just a bit confused with MSQLyog's menus!
basically lets just say i have a cars table with the primary key as MAKE and a Person table! what i want to do is create a foreign key in the person table (MAKE). The option to allow you to do this in yog is a bit confusing.
do i select the cars table and then select the relationships option?? or is it vice versa? also is the referenced table in my case the person table?
which is the source column and which is the target column in the example above?
thanks for your help!