Free Lessons
Courses
Seminars
TechHelp
Fast Tips
Templates
Topic Index
Forum
ABCD
 
Home   Courses   TechHelp   Forums   Help   Contact   Merch   Join   Order   Logon  
 
Back to Access Forum    Comments List
Upload Images   @Reply   Bookmark    Link   Email   Next Unseen 
Normalization Relationships
Dan Hall 
    
4 years ago
I am trying to start a DB for my son's contractor business. I started by creating two tables called CompT for Companies and HumT for Humans. I created a Many to Many Relatioonship between as each Company can have many Humans and each Human can have Many Jobs with multiple Companies. Can I use this method as I was going to start a CustomerT where it shows all the CompanyNames in a CustName Combo box, but then I realized that he has some Companies and some Individual Humans as Customers. What am doing wrong here because I want all Humans and Companies Listed in same Combo Box. So I created a Union Query to Combine the Companies and Human ( Fullnames ) that i joined together from Human Table that was broken down to Salut / FName / Middle Initial / LastName and Suffix. This is confusing me. Is this the right way to go or should I have a Simple Customer Table that lists the Company Name or the Fullname of the Customer ? Please Help. I tried to shorten but need to explain in full
Dan Hall OP  @Reply  
    
4 years ago
This just a test to see where the responses can be viewed . . .
Adam Schwanz  @Reply  
           
4 years ago
Watch this Too Many Tables

Keep tables together that contain similar information. In your case, I assume it's very similar information between CompT and HumT, you'd have a name, phone, address, contact person if applicable. I'd just put them into a ContactT and if you need to sort out if it's a company or a human just use a yes/no checkbox or combo box.

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Access Forum.
 

Next Unseen

 
New Feature: Comment Live View
 
 

The following is a paid advertisement
Computer Learning Zone is not responsible for any content shown or offers made by these ads.
 

Learn
 
Access - index
Excel - index
Word - index
Windows - index
PowerPoint - index
Photoshop - index
Visual Basic - index
ASP - index
Seminars
More...
Customers
 
Login
My Account
My Courses
Lost Password
Memberships
Student Databases
Change Email
Info
 
Latest News
New Releases
User Forums
Topic Glossary
Tips & Tricks
Search The Site
Code Vault
Collapse Menus
Help
 
Customer Support
Web Site Tour
FAQs
TechHelp
Consulting Services
About
 
Background
Testimonials
Jobs
Affiliate Program
Richard Rost
Free Lessons
Mailing List
PCResale.NET
Order
 
Video Tutorials
Handbooks
Memberships
Learning Connection
Idiot's Guide to Excel
Volume Discounts
Payment Info
Shipping
Terms of Sale
Contact
 
Contact Info
Support Policy
Mailing Address
Phone Number
Fax Number
Course Survey
Email Richard
[email protected]
Blog RSS Feed    YouTube Channel

LinkedIn
Copyright 2026 by Computer Learning Zone, Amicron, and Richard Rost. All Rights Reserved. Current Time: 5/7/2026 6:22:01 AM. PLT: 1s