I am creating a simple two form data access application. The first form
displays my main table that shows orders in an orders table. I have a command
button that opens a second form that show a related table that contains all
of the order details. I know there is a simple code that I can put in the
form load that will link the order detail form to the orders form based on
the orderid.
Any help is greatly appreciated.
Thank you,
ericzaj
Cor Ligthert [MVP] - 09 Oct 2005 08:25 GMT
Eric,
This is a general newsgroup. A nice newsgroup to start your questions and to
help you to find better ones
*Next* time you can place these questions like this better crossposted (if
your newsreader is able to do that) based on relevancy in the newsgroups
microsoft.public.dotnet.languages.vb
microsoft.public.dotnet.framework.adonet
On this website you find in more ways answer on your question. I give you
one example because I don't even know what database you use.
http://www.windowsformsdatagridhelp.com/default.aspx?ID=a1a84750-08df-49b4-8657-
7bc3068aca2c
There are more samples on our website of this, by instance using textboxes,
SQL server instead of Access etc.
I hope this helps,
Cor
ericzaj - 09 Oct 2005 17:18 GMT
It is an Access database. I have all the bindings and dataadapters set
properly. All I need now is to be able to link a related form that gives
details about an order . If on the main form I am looking at orderid 123456,
I want the form that displays the details of all orders to open based on the
record of 123456.
Thank you,
ericzaj
> Eric,
>
[quoted text clipped - 18 lines]
>
> Cor
Ralph - 13 Oct 2005 14:29 GMT
Try relating the two tables, it is, as I see it, the order details table and
the order table must be related thru the order code. If you relate this two
tables, the datagrid will allow the user to "expand" the order and navigate
to the order detail table without having to open a new window or datagrid.
> I am creating a simple two form data access application. The first form
> displays my main table that shows orders in an orders table. I have a command
[quoted text clipped - 5 lines]
> Thank you,
> ericzaj