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

  • Thread starter Thread starter Aamir Ghanchi
  • Start date Start date
A

Aamir Ghanchi

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.
 
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
 
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.
 
Back
Top