By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
425,677 Members | 1,877 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 425,677 IT Pros & Developers. It's quick & easy.

form controls for relational tables with one-to-one correspondence

P: n/a
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.
Nov 15 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
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" <aa**********@yahoo.com> wrote in message
news:a6**************************@posting.google.c om...
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.

Nov 15 '05 #2

P: n/a
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" <do********@comcast.nospam.net> wrote in message news:<uP**************@tk2msftngp13.phx.gbl>...
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" <aa**********@yahoo.com> wrote in message
news:a6**************************@posting.google.c om...
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.

Nov 15 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.