>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