I am following your videos, trying to learn Access programming. I have been studying (?) the TechHelp Free Template v 1.82 where you have a Customer database. In the Customer database, all of the customers are individuals. My question are:
How would I handle (add) Companies to the database? Would I setup a Company table with a CompanyID field?
-OR-
Should I incorporate a Company field into the Customer database?
Thank you for making these videos.
Kevin Robertson
@Reply 4 years ago
If it is a customer, just add a CompanyName field to the Customer table.
Kevin Yip
@Reply 4 years ago
Company info is much more complicated than individual persons' info. In my old job, not only did each company have the basic contact info (name, address, phone, etc.), but also:
- Multiple ship-to locations, such as companies that own stores in several places.
- Multiple bill-to locations, because larger companies often have multiple invoicing departments.
- Multiple distribution centers, or "hubs" that distribute goods to other locations.
Different companies may also use different "payment terms." One may use "Net 10 EOM" (payment due 10 days after end of month), and another may use "8/10 ROG" (8% discount if paid within 10 days after receipt of goods). So your company need to store these for different companies.
It all depends on your business practices. Some industries or businesses require more complicated info than in others.
Yep. It's all how you want to handle it. You can do one company with multiple people at that company (2 tables). You can just add a company name to the customer table (1 table). You can also make companies and people a single unit called an "entity" which is what I do in my ABCD. Then you can relate them all together with self-joins. All about how YOU want to put your Legos together.
Sorry, only students may add comments.
Click here for more
information on how you can set up an account.
If you are a Visitor, go ahead and post your reply as a
new comment, and we'll move it here for you
once it's approved. Be sure to use the same name and email address.
This thread is now CLOSED. If you wish to comment, start a NEW discussion in
Visitor Forum.