How do we create relation ships between tables using a sql query?
im using MS Access and VB.net.
Please post an example,tht would b really appreciated.
Jump to Post
First you need to understand a whole lot about keys and constraints.
Creating a Table with a Foreign Key Reference
This demonstrates how to create a table with a foreign key. In this example, I define two foreign key references within the definition of a CREATE TABLE statement:
All 2 Replies
Be a part of the DaniWeb community
We're a friendly, industry-focused community of 1.20 million developers, IT pros, digital marketers, and technology enthusiasts learning and sharing knowledge.