Hi,

How do I create a relation between a Master Table and its Child Table in
Access.MDB using ADO.NET.
Ex: I need to create a relationship between InvoiceNo from tblInvoice to
InvoiceNo from tblInvoiceDetail.
I need to create a Foreign Key that link CustomerID from tblInvoice to
CustomerID from tblCustomer

Anyone help?

Thank You,
mfwoo

Hi,

You would need to use COM-based ADOX to do this. ADO.NET does not support
it.

--
Val Mazur
Microsoft MVP

http://xport.mvps.org



"Woo Mun Foong" <(E-Mail Removed)> wrote in message
news:BAF94231-FEC3-43A3-9DC5-(E-Mail Removed)...
> Hi,
>
> How do I create a relation between a Master Table and its Child Table in
> Access.MDB using ADO.NET.
> Ex: I need to create a relationship between InvoiceNo from tblInvoice to
> InvoiceNo from tblInvoiceDetail.
> I need to create a Foreign Key that link CustomerID from tblInvoice to
> CustomerID from tblCustomer
>
> Anyone help?
>
> Thank You,
> mfwoo
>

Dear Val Mazur,

Can you kindly point me to the said references ?


Thank You,
mfwoo


"Val Mazur (MVP)" wrote:

> Hi,
>
> You would need to use COM-based ADOX to do this. ADO.NET does not support
> it.
>
> --
> Val Mazur
> Microsoft MVP
>
> http://xport.mvps.org
>
>
>
> "Woo Mun Foong" <(E-Mail Removed)> wrote in message
> news:BAF94231-FEC3-43A3-9DC5-(E-Mail Removed)...
> > Hi,
> >
> > How do I create a relation between a Master Table and its Child Table in
> > Access.MDB using ADO.NET.
> > Ex: I need to create a relationship between InvoiceNo from tblInvoice to
> > InvoiceNo from tblInvoiceDetail.
> > I need to create a Foreign Key that link CustomerID from tblInvoice to
> > CustomerID from tblCustomer
> >
> > Anyone help?
> >
> > Thank You,
> > mfwoo
> >
>
>
>

On Wed, 17 Aug 2005 18:29:03 -0700, "Woo Mun Foong" <(E-Mail Removed)> wrote:

¤ Hi,
¤
¤ How do I create a relation between a Master Table and its Child Table in
¤ Access.MDB using ADO.NET.
¤ Ex: I need to create a relationship between InvoiceNo from tblInvoice to
¤ InvoiceNo from tblInvoiceDetail.
¤ I need to create a Foreign Key that link CustomerID from tblInvoice to
¤ CustomerID from tblCustomer
¤

ADOX, as Val mentioned, is one way to do it. However, I would recommend Jet SQL DDL instead to avoid
having to use COM interop:

http://msdn.microsoft.com/library/de.../acfundsql.asp
http://msdn.microsoft.com/library/de...l/acintsql.asp


Paul
~~~~
Microsoft MVP (Visual Basic)