I came to the same conclusion as other posters that you need to reprogram relationships between tables but do not want to accept it, especially since I
spent so much time setting the relationships up in the first place (in the
Db)!
It does not make sense that VB.NET through ADO.NET can't simply be the front
end to the Access DB in the back.
I now use a datagrid to show one of my child tables, but one column contains
data from another (parent) which I want the user to select when adding a new
child record, just as he would when having the table open in Access (a
dropdown list would appear when selecting the field). How do I get this
'parent' column to display the same dropdown list in the datagrid as in
Access itself? In my datagrid, the new record does not show the valid options
in this field, thus the user is forced to type it in and make sure his entry
is correctly spelled(!).
Re: Parent -Child relationship ...Binding with relations has forever been a problem in 1.1. ...Child Table ... Then I bind the parent table to a DataGrid and the DefaultView of the ... (microsoft.public.dotnet.framework.adonet)
Re: Dataset - How to get data from a child table? ...listview see which one is better for my case. ... need to consider if I use datagrid.... >> Than you can use in that an expression to the parent.... I'm worring on the performance coz I ... (microsoft.public.dotnet.languages.vb)
Re: Related column values ... Don't forget to include the "Parent."... referring a parent table from its child, to refer a child from its parent ... > UserID is related to Users' ID column via a DataRelation. ... > Also, any examples, tutorials on DataGrid are gladly appreciated. ... (microsoft.public.dotnet.framework.windowsforms.controls)
Re: Binding to a related column ... Don't forget to include the "Parent."... referring a parent table from its child, to refer a child from its parent ... > UserID is related to Users' ID column via a DataRelation. ... any tutorials on DataGrid are gladly appreciated. ... (microsoft.public.dotnet.framework.windowsforms.databinding)
Re: newbie - simple Master/Details question ... I changed the way I handle my SQL, and made the child table's SQL statement ... fields being searched upon in the parent, don't occur in the child - it got ... In MSHFlexGrid, the only navigation was the "+" button, and the scroll ... I am trying to find a way of doing this in a single datagrid though, ... (microsoft.public.dotnet.framework.adonet)
