Forum Discussion

JeffL1961's avatar
JeffL1961
Copper Contributor
May 01, 2024

Access Primary Key

Hello Access Community, I am beginner user to Access; 365 for Desktop. I am creating a new Customer Table that has many Parents and many Children of those Parents. More Parents and/or Children are added throughout the month. How do I create a Primary Key for this Customer table? If I use an Auto Number then I will need to use a VLOOKUP function to match both each month, and this process will keep taking longer as new Parent and Children are added. Thank you in advance for your help! 

 

  • There is no VLOOKUP in Access.

    Customers have parents and children? What do you mean? Is this for example a doctor's office where record 1 is the mom, record 2 is the dad, and records 3, 4, 5 are their children? Please tell us your real-world scenario so we don't have to use abstract language.
    • JeffL1961's avatar
      JeffL1961
      Copper Contributor

      Tom_van_Stiphout 

       

      Hi Tom,

       

      Thank you for taking time to reply. Much appreciated. I was referring to an Excel VLOOKUP outside of Access and then loading the results into Access. This is a printing business. There are 50 Parent companies, and each Parent company has approximately 20 subsidiaries. Therefore, sales orders can be any combination within these Parent and subsidiary companies. Also, we have 20 different sales people. Each salesperson has their own sales number. For example, 701. These sales people are usually assigned several Parent companies. However, let's say one of those sales people are on vacation, then you might have a sales person who does not normally service that specific customer perform a sale. So you have many Parent Companies, many Subsidiaries, and more than one sales person handling these accounts. Please let me know if you need any additional information. Thanks again for your help!

    • Deleted's avatar
      Deleted
      Hi Tom,
      I could really use your help solving my above issue; I am currently spinning my wheels and wasting time. Is there anyway I can send you a couple sample tables and get your feedback? Thank you! JeffL1961
      • Tom_van_Stiphout's avatar
        Tom_van_Stiphout
        Steel Contributor

        Sure. Send me a sample db. tom 7744 at cox dot net.
        I can look at it tonight.

Resources