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

    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
    Sep 2003
    Location
    The extremely Royal borough of Kensington, London
    Posts
    778
    Select st.address
    from ship_to st
    where st.id = param

    Alternatively,

    Select c.details, st.address
    from ship_to st
    INNER JOIN
    customer c ON
    st.id = c.id AND
    st.id = param
    Bessie Braddock: Winston, you are drunk!
    Churchill: And Madam, you are ugly. And tomorrow, I'll be sober, and you will still be ugly.

Posting Permissions

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