>Hello,
>
> I was wondering if anyone knows how to create a 1 to many relation between tables using SQL Server? Is this something that would be done on the server or does it have to be done from VB with a select statement?
>
>Thanks
>
>Jim
A one to many relationship would be set with a foreign key constraint either with a SQL statement or with the Enterprise Manager.
Then on your VB code you would use a SQL join whenever you need related data from both tables.
HTH
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only