12.6. Services and Charges

 < Day Day Up > 

How you build this form really depends on how you build the billing form. It is probably best to have a master bill record with a billing ID, customer ID, and date, along with a subform that holds each item, quantity, and default price. Also, have a field to override the price, to meet the requirements requested by the client. If you have that setup on the billing records, the services and charges table is relatively simple. For each type of service provided, have an ID field, the name of the service, the general ledger account that this revenue is booked to, and a default price.

     < Day Day Up > 


    Integrating Excel and Access
    Integrating Excel and Access
    ISBN: 0596009739
    EAN: 2147483647
    Year: 2005
    Pages: 132

    flylib.com © 2008-2017.
    If you may any questions please contact us: flylib@qtcs.net