Form SetUp Help Needed

[etrain]

I am building a contract management application. The application has a contract header table, contract document table, and then 4 different contract details tables. (These are for the different types of details like Software, Hardware, Training) There is a relationship of 1:m respectively between the tables.
Once specific piece of data that goes in the detail tables is payment milestones. There can be multiple milestones with varying percents for every single record in the detail tables. Here again a 1:m relationship. I set up a table for the Actual Payment Milestones, it stores the Detail Records ID as well as its own UniqueID. So in this table you can add many milestones for each of the detail records while maintaining a 1:m relationship.

As far as forms and data entry. Right now it is set up where they enter the contract header info, contract document info, the detail info and for every detail record they open a form to enter the milestones. This works except it is tedious and time consuming. The payment milestones are almost always the same for each of the detail records, but not always so there needs to be milestones for each details, I can't get around that.

Here is what I want to do:
I want the end user to open a form that you enter the contract document number click a button and the form populates with all the detail records related to that document. I want the user to be able to add milestones to each of these records in a mass update sort of way or individually if they chose.

I thought of a form with check boxes, one for every possible milestone trigger. (problem here is updating the form every time a new milestone type are added). I made it a continuous form so I could list all detail records on one page. Main problem here is the check boxes are unbound and so when you check one it checks all. If this did work the plan was to add code to do append queries to add milestones for each record depending on which milestone check box was mark.

Sorry that is was so long. If anyone thinks they might be able to help please reply. If you need more info please let me know and I will provide. There are also Maintenance Milestone Triggers I need to do something similar so this would fix 2 issues I have.

Thanks
e-train

 

[Jusfire]

It's late and I just browsed through ... but what caught my eye was that you said your unbound checkboxes act as one. That doesn't seem right. I would guess that they are all named the same.

 

[etrain]

What I mean is that if I set up a form bound to the table or query, then add the fields to the form. Then add 5 unbound check boxes next to that. These 5 check boxes are independent but when it is set to continous form to view all the item in a list the check boxes repeat down. It is these boxes that act as one.
Example:
Field1 - Field2 - Field3 - Checkbox1 - Checkbox2 ...
Data1 Data1 Data1 Yes No
Data2 Data2 Data2 Yes No

If by clicking one checkbox in the Checkbox1 column all of them are marked the same all the way down.

Make sense? If the checkbox is bound then I do not have the problem.

I know what I trying to do really, I am just having a hard time explaining it. Remember the Past, Plan for the Future, yet Live in the Now for tomorrow may never come.
-etrain