Form Design help needed

[jeo]

I have a form where a user selects a project, then a staff for that project, then managers name, then unit, and then a reponsibility for that person.
After that I have 5 sets of calendars (5 start and 5 end dates: start1, end1, start2, end2, etc...) due to the type of report I want to get out of this, this start1, end1 thing isn't going to work. What I'm thinking can probably be done is to "detach" that form from my database - create a blank form with the above fields and 5 sets of calendars and once a person hits save record, I'm thinking there has to be code that can go into that particular table and create up to 5 records for me (depending on amount of start and end dates).
Can some one help me with this or is this even doable?
The reason why I want it so the user doesn't have to go in to the form 5 times and select same project, same manager, same unit...etc, just different dates.
Thank you for all your help!

 

[daveUK]

You need to use a main form and a subform. On the subform you can have the start and end dates and everything else can go on the main form. There will also need to be 2 tables. One, which the main form is based on and the other, which the subform is based on.

 

[jeo]

I will try that.
Thank you!