Home > Archive > C# > March 2004 > form controls for relational tables with one-to-one correspondence
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
form controls for relational tables with one-to-one correspondence
|
|
| Aamir Ghanchi 2004-03-28, 10:28 pm |
| Hi,
What form controls should I use to manage the data thats in relational
tables. Each relTable may have no row OR one row corresponding to the
row in master table. Probably this is more of a database design
question than programming logic.
| |
| William Ryan eMVP 2004-03-28, 10:28 pm |
| A grid is probably best suited to this task if I understand your question
correctly. You can use a DataRelation to relate the fields and then set the
DataSource accordingly...
HTH,
Bill
"Aamir Ghanchi" <aamirghanchi@yahoo.com> wrote in message
news:a63b84b3.0402181415.20518efe@posting.google.com...
> Hi,
>
> What form controls should I use to manage the data thats in relational
> tables. Each relTable may have no row OR one row corresponding to the
> row in master table. Probably this is more of a database design
> question than programming logic.
| |
| Aamir Ghanchi 2004-03-28, 10:28 pm |
| That would be my choice too. But a DataGrid is meant for one-to-many
relationship . I want, at the most, one record in each of the
secondary table. Can I restrict the user to insert no more than one
one row in the grids.
"William Ryan eMVP" <dotnetguru@comcast.nospam.net> wrote in message news:<uPZUIEn9DHA.3820@tk2msftngp13.phx.gbl>...[color=darkred]
> A grid is probably best suited to this task if I understand your question
> correctly. You can use a DataRelation to relate the fields and then set the
> DataSource accordingly...
>
> HTH,
>
> Bill
> "Aamir Ghanchi" <aamirghanchi@yahoo.com> wrote in message
> news:a63b84b3.0402181415.20518efe@posting.google.com...
|
|
|
|
|