Relationships with More than 2 Tables in Microsoft Access: Assign Orders to Projects for Budgeting

In this video, I'm going to show you how to set up relationships between three tables. We already have a database with customers and orders. We're going to add a projects table for budgeting. Each customer has multiple projects. Every invoice is billed to a project. This now becomes a database with relationships between three tables.

Will from Everett, Washington (a Platinum Member) asks: In my business, we have customers. Customers have projects. Orders must be assigned to a project for budgeting purposes. I see in your Invoicing database how you can assign an order to a customer, but how could I assign that to a project instead? I don't understand how I can then tell what customer the order belongs to. I'm confused. How can I get the CustomerID into the order table if the order is assigned to a project?

Silver Members and up get access to an Extended Cut of this video. Members will learn how to show only projects for the current customer in the order form combo box. We'll display the budget info on the project form and show the budget remaining on the order form. We'll also discuss instances when you might want to store that CustomerID in the order table as well as the ProjectID (a little Database Theory 101 for you today).

MEMBERS VIDEO:
   • Project Budgets MEMBERS ONLY EXTENDED CUT ...  

BECOME A MEMBER:
YouTube:    / @599cd  
or My Site: https://599cd.com/THMember

PRE-REQUISITES:
Invoicing: https://599cd.com/Invoicing
Intro to VBA: https://599cd.com/IntroVBA

LEARN MORE:
https://599cd.com/ProjectBudgets

RECOMMENDED COURSE:
Access Fiscal Year Seminar: https://599cd.com/Fiscal

LINKS:
Relationships: https://599cd.com/Relationships
Aggregate Query: https://599cd.com/Aggregate
Open Form: https://599cd.com/OpenFormSpecific
Enter Parameter Value: https://599cd.com/EPV
Relational Combo: https://599cd.com/Relational
Value From a Form: https://599cd.com/FormName
Calhoun Tubbs:    • In Living Color - Best of Calhoun Tubbs (D...  
Outer Joins: https://599cd.com/OuterJoin
NZ Function: https://599cd.com/nz
Cascading: https://599cd.com/Cascading
Access SQL Seminars: https://599cd.com/SQL

FREE TEMPLATE DOWNLOADS:
TechHelp Free Templates: https://599cd.com/THFree
Blank Template: https://599cd.com/Blank
Contact Management: https://599cd.com/Contacts
Order Entry & Invoicing: https://599cd.com/Invoicing
More Access Templates: https://599cd.com/AccessTemplates

ADDITIONAL RESOURCES:
FREE Access Beginner Level 1: https://599cd.com/Free1
$1 Access Level 2: https://599cd.com/1Dollar
Donate to my Tip Jar: https://599cd.com/TipJar
Get on my Mailing List: https://599cd.com/YTML
Contact Me: https://599cd.com/Contact
TechHelp: https://599cd.com/TechHelp
Consulting Help: https://599cd.com/DevNet
Twitter:   / learningaccess  
https://en.wikipedia.org/wiki/Microso...
https://products.office.com/en-us/access
https://microsoft.com/en-us/microsoft...

KEYWORDS:
access 2016, access 2019, access 2021, access 365, microsoft access, ms access, ms access tutorial, #msaccess, #microsoftaccess, #help, #howto, #tutorial, #learn, #lesson, #training, #database, customers, projects, budgeting, billing, reverse lookup, budget query, project combo box, set default project, calculate budget overrun, amount left in budget, calculate budget remaining, budgeting database

QUESTIONS:
Please feel free to post your questions or comments below. Thanks.