Results 1 to 4 of 4

Thread: Data Help

  1. #1
    Join Date
    Sep 2003
    Location
    Morro Bay
    Posts
    16

    Unanswered: Data Help

    Ok, I have two tables, one with a list of 48,000 + Zip codes with city and state, the other with a list of guests that have stayed with us. I then have a query that my employees use to enter the guest information, when they do so they enter the zip code and the city and state is pulled from the zipcode table and auto fills the data.

    The problem I am having is that if I open the guest table, the only information that transfers back from the query is the zipcode, the city and state information do not save in the main table.......

    any ideas on how I can fix this?

    I thought that maybe I could make the city and state information auto fill from the zipcode table to the guest table rather than from the zipcode table to the guestentry query, but I have had no luck doing so.

    Any help would be apreciated.........and thanks in advance.
    The Matrix will always have you....

  2. #2
    Join Date
    Dec 2002
    Location
    Préverenges, Switzerland
    Posts
    3,740
    why would you want to do this?

    since your zip table can provide city/state any time you need it for mailings etc and your zip is saved in the main table, you do not need to & should not want to duplicate city/state in the main table.

    izy

  3. #3
    Join Date
    Sep 2003
    Location
    Morro Bay
    Posts
    16

    thanks

    Thanks for the tip, I didnt even think of it that way.........
    The Matrix will always have you....

  4. #4
    Join Date
    Oct 2003
    Location
    Roanoke, Va
    Posts
    445

    Smile Re: thanks

    Originally posted by neo_2077
    Thanks for the tip, I didnt even think of it that way.........

    Welcome to the relational database.

Posting Permissions

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