Previous Article Next Article How To Quickly Create Relationships In SQL Server 2014
Posted in Sql

How To Quickly Create Relationships In SQL Server 2014

How To Quickly Create Relationships In SQL Server 2014 Posted on July 14, 201817 Comments



In this video Steve Bishop explains how to quickly create foreign key to primary key relationships in Microsoft SQL Server 2014.

17 comments

  1. In setting up the relationship that way does that turn the field into a Look-up field? The only way I know how to create relationships is by making a field a Look-up field. Thank you!

  2. Steve, I get an error message that the ALTER TABLE statement conflicted with the FOREIGN KEY constraint. It tells me where, exactly, the conflict occurred (i.e., database, table, and column) but I cannot find any "ALTER TABLE" statement anywhere associated with the table and column specified. Am I just looking in the wrong place, or should I change the "Enforce Foreign Key Constraint" option to NO?

  3. Hi Steve, I have moved my back end to AZURE Sql and want to use Access 2013 front end with linked tables. I noticed that Azure does not support relationships, so I wonder how I can avoid data integrity problems and orphan records. I would apreciate your thoughts on this. Thank you very much in advance.

  4. Hello steve, would you please work on naming your videos. because when i am looking for tobic i can't see what I am looking for.
    instead of putting programming access after # of video put the topic name.

  5. Hello Steve, your series is very helpful and thank you very much. please continue your videos because we need it. i want asking you how to copy the SQL server database to another PC, i mean when i complete develop my database on SQL server and access how to copy it, and please when you finish this series can you make something about vb.net. thank you very much.

  6. Is there a way to prevent a record from being deleted in the primary table if there is already an existing record in the foreign table? In Access this is what happens when you set up a relationship, if you do not specify otherwise.

Leave a Reply

Your email address will not be published. Required fields are marked *