Record Filtering

[BD]

MS Visual Studio 2005 Pro, C# development: I have a child form with
datagrid view showing customers/locations which is bound to text boxes,
also have a second datagrid view showing workorders related to
locations. Users want to double-click a row in the second datagrid
view to open up child form Work Orders to the selected record in the
second datagrid view. I can open up the form Word Orders but only to
the first record in that table. Any help with this would be greatly
appreciated. My backend database is MS SQL Server 2005 on remote
server.

 

[RobinS]

I'm not sure I understand. You have a form with a DataGridView control
on it that has customers and locations in it.

I'm not sure what is bound to the textboxes -- the same info that
shows in the DataGridView control?

Then you have a second DataGridView showing WorkOrders that relate
to the locations in the first DataGridView. So if they select a
record in the first DGV for customer X and location Y, the work
orders show the records for location Y?

So then you want to open a form to show the details of that
work order selected in DGV2.

Is that right?

What happens if they click on a row in DGV2 and try to bring up
your WorkOrder form? What does the code look like? You need to
pass the info in the row, or the datarecord, or something, to
the Work Order form for it to populate the data there. How are
you doing that?

Robin S.