Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2016
    Posts
    1

    Unanswered: Creating primary IDs for unique combinations

    Hello everyone, I am brand new to this forum. And relatively new to working with databases and Access.

    I am running into an issue where I have to process origin point and end point of multiple records in the form of:

    OriginCity OriginZip DestinationCity Destinationzip

    I ran a simple query to figure out what where the unique lanes we had on this master data and assigned each of them a unique "Lane_id". My intent was to bring back that lane ID to my original master data so I could know to which lane ids applied to each record. But when I do that It turns out that some records are missing zip codes. So while in my unique lane table these lanes with missing zip codes have been assigned a lane_id. In the master table those same lanes do not get assigned the corresponding id after running the update query. Any ideas on how to assign those to the records with some of the missing elements?

  2. #2
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    Unique lanes are?
    Lane id is?
    I'd rather be riding on the Tiger 800 or the Norton

Posting Permissions

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