Field updating

Hello guys!

I'm working on a application that has a form for Material request. This one will record the form ID, the form status (OPEN or CLOSED) and the total amount for the request.

The form is named MATERIAL REQUEST and its fields are:

DATE, PROJECT CODE, LOT, REQUEST ID, TOTAL COST (this data will be calculated from the information of another form) and STATUS. The status field may be OPEN or CLOSED. The idea is that when a request is closed, no more materials can be added to it, but this will be not decided on this form.

Another form, REQUEST ITEMS will record the items that will be included in the material request forms. Each registry will have the data of the materials, quantities and amount, and the material request form they belong to. The information is supplied from a material database already created and the form metioned previously. The fields are:

REQUEST ID, MATERIAL CODE, DESCRIPTION, QUANTITY, COST and TOTAL COST. In the form there will be a check to let the user define if he has ended registering materials on that material request. And here comes the good stuff...

It is needed that when the user defines that he has ended registering items on a given request (defined by its ID on the MATERIAL REQUEST form), the OPEN status must become CLOSED, so no further materials can be added to that specific request. In other words, this field in this form, controls the OPEN/CLOSE field in the other form.

It is needed also to calculate in the MATERIAL REQUEST form, the total amount of the cost of the materials registered to every request. So this total cost will be calculated from the information of the other form.

I hope I could explain clearly what I need. If you need to access to the application, just let me know.

Thanks,

Alberto