Hi Guys,
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.
many thanks.
vammy
-2
Light Poster
Recommended Answers
Jump to PostFirst 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
Reply to this topic
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.