Infopath query and putting datafields per reocrd

[Gildas]

Hi -

I am new to Infopath and am trying to build a project status report. I
am totally stuck on how to force users to enter dates to a list of
milestone we require in each project.

Table: Milestone; has 3 records (start, mid, end)
Table: ProjectStatusReport; Project and StatusDate as primary key;
relate to Milestone table through a MilestoneID; stores dates. (ie:
ProjectID, StatusDate, MilestoneID, ProjectedDate, ActualDate)

Since we may add more milestones into the Milestone table, I was hoping
the ProjectStatusReport would query the Milestone tbl and return a list
of all milestones, which then users can set a date for each of the
milestones. The dates are stored w/n the ProjectStatusReport tbl.

I was able to retrieve a list of all milestone through secondary data
source...however, when i put bindings to ProjectStatusReport's
attributes, all subsequent row values would end up the same! (i think
its b/c its nested w/n a repeating table). Can infopath query the
Milestone table, and automatically add 'ProjectedDate' and 'ActualDate'
in a non-repeating - seperate record? (in this example, the user will
submit 3 records to ProjectStatusReport?)

Any help or suggestions would be much appreciated.

Thanks,
Gildas