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!
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! Read More