Results 1 to 2 of 2
  1. #1
    New Lounger
    Join Date
    Nov 2001
    Thanked 0 Times in 0 Posts

    Input information (access 2000)

    I am trying to put together a Database for an electronic service organisation. Technicians work from a customer form which has all the details they need. If they need to order parts for customer a button is selected from a Workshop form and a Purchase Order form is displayed.This form has the customer, job number and a Combo box of prefered suppliers.What I need to do is have the Technician fill in an order which has columns for Qnty,Description and Part Number.They may order one part or 10 parts so what they need to fill in should expand if they need to order more than one part, this completed form will then be faxed to a supplier and what has been ordered linked to the customer. Any Ideas as I am very new to Access.

  2. #2
    Gold Lounger
    Join Date
    Jun 2001
    Crystal Beach, FL, Florida, USA
    Thanked 40 Times in 39 Posts

    Re: Input information (access 2000)

    What you are describing (being able to enter 1 part or 10 parts) is handled through a subform, a very useful concept. Look through Northwinds to see how subforms are used.
    Mark Liquorman
    See my website for Tips & Downloads and for my Liquorman Utilities.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts