a little access help?:)

Discussion in 'OT Technology' started by phatmonky, Dec 31, 2002.

  1. phatmonky

    phatmonky Guest

    The end result should be a form that I can select a customer name from a combo box, and upon that name it populates the remaining fields with values from a table (address, phone, etc). The values in the combo box come from the same table, entered in a different form.


    Example.
    select "ACME" from the combo box.
    It populates fields with "Acme Corporation", as well as all their info.
    Then I want to enter some comments in another field and I'm done. When I come back to this later, I'd like this all to be a record :)

    thanks in advance :)
     
  2. 5Gen_Prelude

    5Gen_Prelude There might not be an "I" in the word "Team", but

    Joined:
    Mar 14, 2000
    Messages:
    14,519
    Likes Received:
    1
    Location:
    Vancouver, BC, CANADA
    Well let's use the standard ordering template example. The trick is that the form you make has to be based on the order AND the customer information. Each order has a CustomerID field and that is linked to the Customer table via the common CustomerID field.

    Then make the order with the combo box based on the Customer Table with the CustomerID being the value returned (this is pretty simple). NOw all you need is the address and such - well since your form was based on two tables linked, all you do is put the field names for the address info into the form just like any other field. Finally make sure the controls are disabled.

    Customer Table
    --------------------
    CustomerID (autonumber)
    FirstName
    LastName
    Address
    City
    State
    Zip

    Order Table
    ---------------
    OrderID (Autonumber)
    CustomerID (long int)
    Comments
     
  3. phatmonky

    phatmonky Guest

    I was ALMOST there :o
    Thanks so much for the fast reply man :)
     
  4. 5Gen_Prelude

    5Gen_Prelude There might not be an "I" in the word "Team", but

    Joined:
    Mar 14, 2000
    Messages:
    14,519
    Likes Received:
    1
    Location:
    Vancouver, BC, CANADA

Share This Page