I have Groups (MainName) , Subgroups (SubName) ,and Items (Services)
Items belongs to Subgroups and subgroups belongs to Groups.
if i select (Enter) all the Items (Services) that belongs to the Subgroup "CBC" , as in (order 1).
In RptMain: i want to show Group Header "HeadSecndGrop" .
if i select (Enter) some of Items (Services) that belongs to the Subgroup "CBC" , as in (order 2).
in this case in RptMain: i want to hide Group Header "HeadSecndGrop" .
I want to do this in all SubGrpups.
I hope that you may well did you understand my request.
And in Post#3 I told you what you need to do to get the results you want. Have you added a *trigger* to the Table?
Falcon, we are not here to write your database for you. We are UNPAID volunteers here to assist you... period. If you want someone to write your database for you please consider hiring a Developer. However, if you want help then add something to the Table that will be a trigger. The database needs to have some way of telling when/where you want something to show. It only does what you tell it do.
Setting the Default only applies to new records not existing ones. If you want the old ones to be *Yes* then you have to go in and check them. OR you can change my statement to read *False* instead of True.