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 ad...
Forum Discussion
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.
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.
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!