I would like to know how people handle foreign keys with mysql. Has anyone ever created a relationships table for use with other tables? If so, what types of fields did you find necessary to define the relationships? How did you handle parent-child relationships -- when parents are deleted all their children must also be deleted. . .I would really to learn what types of experiences have had.
Thanks in advance, Ward
