I am explaing step by step
1) I Created Parent Tables as "Projects" And "ChildRep"
2) In Projects Table I have Created Two Fields as "Start Date" And "End Date"
3) In ChildRep Table I Have Created Three Fields As "Per_Count" And "Per_Month" And "Per_year"
3) In Projects When click On New Project Button As show Form As look like "Start Date" And "End Date"
4) When i Select Two dates (01/05/2018 to 06/30/2018) and click save close
Insert Records Like Below
Projects Table
RecordId Start Date End Date
1 01/05/2018 06/30/2018
(Note: Established Relation from Projects to ChildRep As "one to many Relations")
(Note: when selected date ranges as 01/05/2018 and 06/30/2018 and listed like below
1 -> 01/05/2018 its not a full month it means (01/01/2018 to 01/31/2018 as a full month) but it selected from 01/05/2018 so we missed 5 days so we treated as full month so we putting 0.95 in Per_Count field in childrep table (full month treated as "1")
2 - >02/01/2018 as full month "1"
3 -> 03/01/2018 as full month "1"
4 - >04/01/2018 as full month "1"
5 - >05/01/2018 as full month "1"
6 - >06/01/2018 to 06/30/2018 (When i selected end date(06/30/2018) as satisfied to month ) as full month "1"
)
I want to this Out Put
ChildRep
RecordId ProjectRecordId Per_Count Per_Month Per_year
1 1 0.95 01 2018
2 1 1 02 2018
3 1 1 03 2018
4 1 1 04 2018
5 1 1 05 2018
6 1 1 06 2018
Thanks
