Hi, I have a form with multiple tables.
when I add rors into the tables I Use code like this:
Dim n As Integer = 0 For Each copyRows1 In copyRows Dim newOrdreRow As DataRow = Kalkyle1DataSet.Tables("Ordre").NewRow() Dim Ordredato As String = Kalkyle1DataSet.Tables("Ordre").Rows(n).Item("Ordedato")
where I add new rows also addin a OrdreID as Foreign Key.
How do I Delete all records in the tabel with the foreign key = * ?
* = a number I choose