May 01 2024 07:10 AM
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!
May 01 2024 10:32 AM
May 07 2024 06:42 AM
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!
May 15 2024 11:16 AM
May 15 2024 11:46 AM
Sure. Send me a sample db. tom 7744 at cox dot net.
I can look at it tonight.
May 16 2024 05:46 AM
May 16 2024 07:22 AM