I have read threads saying you can use defaultview of a datatable to filter the data. What would the code look like to do this for a child table? I have a relation relAccountInvoice and would like to just display invoices with a category of M in a datagrid. This is the code I am trying and it doesn't seem to do anything.
Any ideas?
Thanks,
Joe
VB.NET:
ds.Tables("Account.relAccountInvoice").DefaultView.RowFilter= "CATID='M'"
Any ideas?
Thanks,
Joe