Urgent!!! - Create form to do invoicing (rather long, but important message) 
Author Message
 Urgent!!! - Create form to do invoicing (rather long, but important message)

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



Sat, 12 Feb 2000 03:00:00 GMT  
 
 [ 1 post ] 

 Relevant Pages 

1. Urgent!!! - Create form to do invoicing (rather long, but important message)

2. Urgent!!! - Create form to do invoicing (rather long, but important message)

3. Urgent!!! - Create form to do invoicing (rather long, but important message)

4. Urgent Help needed with classic problem: invoice numbers, transactions, and parent-child form

5. ***Important***Important***Important***Important***

6. Print invoices to email address rather than printer

7. Excel ASSUMES what I want rather than DOING what I say :(

8. URGENT: Error when assigning long strings to Form Fields in a protected Word document

9. Create Invoice Form

10. Overflow message when doing a create table query (Access97)


 
Powered by phpBB® Forum Software © phpBB Group