i have 2 tables one holds and id number for a transaction and the other tables holds the data for that transaction
i can populate the first datagridview with the "id" data.
I want to be able to select the row on the datagridview (id) and show the details for that transaction in another table

Me.Tbl_Transactions_HeaderTableAdapter.ClearBeforeFill = True
Me.Tbl_Transactions_HeaderTableAdapter.Fill(Me.DataSet_Sys.tbl_Transactions_Header)
Me.Tbl_Transactions_HeaderDataGridView.Refresh()

this populates the datagridview with the "id" data, how do i then click on a row and the details show in another datagridview.
if i add the code for the transaction data on form load, then it populates all the tranasction data into the
2nd table

 Me.Tbl_TransactionsTableAdapter.ClearBeforeFill = True
 Me.Tbl_TransactionsTableAdapter.Fill(Me.DataSet_Sys.tbl_Transactions)
 Me.Tbl_TransactionsDataGridView.Refresh()

Instead of filling the detail tableadapter in the load event of the form, you could do that in the "RowEnter" event of the header datagridview.

You need to pass the key to the detail tableadapter. You will find the the key in DataGridView.CurrentRow.Cells("keyfiedColumnName").value.

Let us know if you need help on how to pass the key to the detail adapter.

Good luck.

hi
can you get me more details on how i do this

Post what you already have in your form, would you?

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.