I have a linq to sql dbml file with a tblEquipment table and a tblEquipmentLog table with a one-to-many relationship. I want to drill down to see the equipmentlog for each piece of equipment.

As in the linq to sql example i query the databse like this:

        public rglEquipmentDataContext db = new rglEquipmentDataContext();       

        private IEnumerable<tblEquipment> eQuery = null;
        public IEnumerable<tblEquipment> qEquipment
        {
            get
            {
                if (eQuery == null)
                {
                    eQuery = from e in db.tblEquipments
                              select e;
                }
                return eQuery;
            }
        }

 In my XAML i have CollectionViewSource like this.

        <xcdg:DataGridCollectionViewSource x:Key="cvsEquipment"
                                           Source="{Binding RelativeSource={RelativeSource AncestorType={x:Type Window}}, Path=qEquipment}"
                                           AutoFilterMode="And" 
                                           DistinctValuesConstraint="Filtered">
 

 I've added AutoCreateDetailConfigurations="True" to the grid

I've also added                

<xcdg:DataGridControl.DetailConfigurations>
                    <xcdg:DetailConfiguration RelationName="tblEquipment_tblEquipmentLog"
                                  Title="Equipment Log">
                        <xcdg:DetailConfiguration.Columns>
                            <xcdg:Column FieldName="eqlID"
                           Visible="False" />
                            <xcdg:Column FieldName="eqlUser"
                           Visible="True" />
                        </xcdg:DetailConfiguration.Columns>
                    </xcdg:DetailConfiguration>
                </xcdg:DataGridControl.DetailConfigurations> 

 What else do i need to do to make it work.

Thanks in advnace for you help.