Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2004
    Location
    Orlando Florida
    Posts
    5

    Smile Unanswered: Multiple Ship To Addresses

    Hi All,

    I am a new Access user and having a mental block concerning queries. What I am trying to accomplish is selecting Ship To address from a list of Shp To addresses in a combo box. I would then enter selection on the invoice. Most of my customers have more then one Ship To address.

    Here is the current setup. I have separate Customer and Ship To tables. Every Ship To address is assigned the same ID number as customer ID. If customer ID is “AL100” then all Ship To’s for that customer will have “AL100” as ID number.

    What I want to happen first is, Select customer to invoice. Then Select “Ship To” address from a combo box. All Ship To for that customer would be displayed in the combo box. I have been trying without success to create a query to filter all ID’s for that customer.

    Thanks for your help.

    Daryl

  2. #2
    Join Date
    Jan 2004
    Location
    Orlando Florida
    Posts
    5

    Re: Multiple Ship To Addresses

    Sorry I placed this in wrong fourm...I'll resubmit in Access Fourm.

    Thanks
    Originally posted by DarylS
    Hi All,

    I am a new Access user and having a mental block concerning queries. What I am trying to accomplish is selecting Ship To address from a list of Shp To addresses in a combo box. I would then enter selection on the invoice. Most of my customers have more then one Ship To address.

    Here is the current setup. I have separate Customer and Ship To tables. Every Ship To address is assigned the same ID number as customer ID. If customer ID is “AL100” then all Ship To’s for that customer will have “AL100” as ID number.

    What I want to happen first is, Select customer to invoice. Then Select “Ship To” address from a combo box. All Ship To for that customer would be displayed in the combo box. I have been trying without success to create a query to filter all ID’s for that customer.

    Thanks for your help.

    Daryl

Posting Permissions

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