Hi all,
i have two table that they have some like fields for example
tbl1 {pid,name,family,sex,modality,description}
and
tbl2{pid,name,family,sex,modality,description,createDate,path}
my main question is how to show the all records of the tables in a binding target(datagrid,listview,...) with this Conditions
1- if two records or more records founded that they name,family and sex was equal show they as one record and show modality data in modality column same cx,mr,io,...
2-when founded same records i want add a button side of name when contains sub record exactly inside name cell for show sub record
3-when the button is clicked each field of sub row must show under main column header after collapse
4-i dont want use groupby because group header is not a row
Is there any way to implement this scenario?
Please explain fully.
Thanks all.