Re: Sql server 2005 Many to Many relationship

You must create a third table that will hold the reference to each of the
table and use to store your many-to-manyu relationship. This is the usual
design with all relational databases and it doesn't change with Sql-Server
2005, ADO or ADO.NET.

--
Sylvain Lafontaine, ing.
MVP - Technologies Virtual-PC
E-mail: sylvain aei ca (fill the blanks, no spam please)


"Manjree Garg" <garg@xxxxxxxxxxxxxxxx> wrote in message
news:2C13A2E0-7BB1-4E24-942F-101468F88348@xxxxxxxxxxxxxxxx
Hi

I am developing a Sql Server 2005 database and using ADO.Net to access it
in VC++ 2005.
Is there some way of defining many-to-many relationship between two
tables(e.g. Experiment and SampPrep).

Any suggestions will be appreciated.

Thanks.

Manj


.

Relevant Pages

  • Re: How do you pass data to a new record from an existing record?
    ... It is not only possible, but desirable, in relational databases, to use ... Customers), you wouldn't need to re-store customer name, address, ... ... > actually need to store that information more than once. ... > used those names as a generic reference so it would be easy to understand ...
    (microsoft.public.access.forms)
  • Re: List question
    ... The heart of relational databases like Access is the one-to-many idea. ... related table to store the many choices for the ... continuous view so you can enter as many lines as you need in the subform ... and an append query for any item that is now ...
    (microsoft.public.access.forms)
  • Re: SQL Syntax Problem
    ... If not, store ... Sylvain Lafontaine, ing. ... DoCmd.RunSQL "INSERT INTO tblDiscrepantItems (prod, qtyonhand, qtycnt, ... at end of SQL statement. ...
    (microsoft.public.access.modulesdaovba)