Changing values from past records

[spleewars]

Got a complicated challenge (better define my last challenge) but don’t have a clue where to start: I’ll try to be accurate as possible. Apologies I might be asking for a lot of coding but this has been bothering my for a lot of weeks trying to do it myself the ‘simple’ way but failed all over every time. This is all about automatic changes in particular field of a past payment.

Got form “Report” and subform “Bank”. The purpose of this form is to input payments made that day. In report form, the user set 1 daily record to save day details and the subform is filled with tens of records about customers and payment amounts.

In”Report” I got 2 particular fields:

Date: is set daily by the user
Dailyid: (as autonumber related to the subform)

In “Data” I got 2 important fields:

OrderID (order id inputted by the user which is the identity of the client)
Status: (combo box with option1, option2 and option3)

Example: on 18-Feb-2012 customer came to process a payment. A record in “Report” is open with the daily date and another record in the subform is set to mark OrderID ‘4512452’ and ‘Status’ field, which is set by the user as default to‘option1’. On 23-Mar-2012, the same customer is about to process another payment. Apart the same procedure is performed, when the user is about to save the new payment details, the field ‘status’ of the payment before (which in this case made on 18-Feb-2012), from opion1 is set automatically set to option3…

Thanks everyone for help
Clara

 

[Uncle Gizmo]

First of all can I assume that the "order ID" will be unique and only relate to a particular order? I ask this because you state "OrderID (order id inputted by the user which is the identity of the client)".

I realise that what you are probably saying is the order is linked to a client, however the issue is that clients don't necessarily pay for individual orders, they pay on statements which may contain several different orders.

They may also withhold payment for a particular order if there is a problem with that order.

In a situation where they are withholding payment for a particular item you may receive a partial payment, or there may be other reasons for receiving a partial payment, in other words it would be sensible to be able to list the total amount paid, and then have some method of allocating a proportion of a payment to the different orders the total payment may relate to.