Friday, February 24, 2012

How do I do this with SQL Express?

Hi,

In Microsoft Access when I had a one-to-many relationship between tables, I could (in the master\parent) table enter a record and a plus symbol would appear enabling me to enter the many side details. How can this be done in SQL Express?

Thanks for your help

A

hi A,

what do you mean by that?

SQLExpress is "just" an engine where Access (in this case) is a client application... you have to programmatically deal this in your app as you require... say something similar to http://search.msdn.microsoft.com/search/default.aspx?siteId=0&tab=0&query=master+detail

regards

No comments:

Post a Comment