To any person(s) who is kind enough to help me with the following problems.

I am an inexperienced developer and would like to create a form which
enable me to do invoicing. I am using Access Ver 2.00 (windows 3.11)

The form will have these fields: Order ID; Product ID; Ordered Qty; Ordered
Amt($); Shipped Qty; Shipped Amt; Shipped-to-date Qty; Shipped-to-date Amt;
Backorder Qty; Backorder Amt; Invoice ID and Invoice Date.

Upon opening the form, this is what I want the program to do; see
illustration below:

STAGE           DESCRIPTION                             FIELDS* / ENTRIES
                                                OID  | PID |    OQ     |    SQ   |   STD   |   BQ

(A)     Enter a valid ORDER ID, related
        details appear on the form (as many
        product ordered)                                1        2       10($10)     0($0)     0($0)    0($0)
(B)     Perform 1st invoicing with such info
        entered                                 1        2       10(10)       2(2)       0(0)        8(8)
(C)     ..... at later date, when enter same
        ORDER ID, the info
        shall be updated to show......          1        2        8(8)          0(0)    
2(2)        0(0)
(D)     Perform 2nd invoicing with such info
        entered                                 1        2        8(8)          3(3)      2(2)        5(5)
(E)     ....etc...., until all orders had been
        shipped and invoiced.

Note: FIELDS*: OID = Order ID; PID = Product ID; OQ = Order Quantity (Qty);
SQ = Shipped Qty;
STQ = Shipped-to-date Qty; BQ = Backorder Qty.

QUESTIONS:
Q1 How do I get the program to display information as at stage (A)?
Q2 How do I get the program to update the information when at stage (C)?
Q3 Based on the illustration above, what are the underlying tables that I
need to support this operation?

These are the various problems which I would very much like to solve.  If
you can help, I would most  happy to hear from you.  My email address is

Best Regards
Stephen Then