Re: Best practice on Foreign Keys Thread #1382748 Message #1382848

I looked through the Jump start as you suggested. I do not see where the Shipper and Employee tables are ever joined. The jump start shows the creation of the classes and the stored procedures, but no relationships.

I like where your going with this, but I still don't know how and where the relationship needs to be done. The record will need to be edited so that when a Crew row is being added the end user has a dropdown box with all of the possible CrewTypes for selection.