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 MEMBER...
BECOME A MEMBER:
TH-cam: / @599cd
or My Site: 599cd.com/THMe...
PRE-REQUISITES:
Invoicing: 599cd.com/Invo...
Intro to VBA: 599cd.com/Intr...
LEARN MORE:
599cd.com/Proj...
RECOMMENDED COURSE:
Access Fiscal Year Seminar: 599cd.com/Fiscal
LINKS:
Relationships: 599cd.com/Rela...
Aggregate Query: 599cd.com/Aggr...
Open Form: 599cd.com/Open...
Enter Parameter Value: 599cd.com/EPV
Relational Combo: 599cd.com/Rela...
Value From a Form: 599cd.com/Form...
Calhoun Tubbs: • In Living Color - Best...
Outer Joins: 599cd.com/Oute...
NZ Function: 599cd.com/nz
Cascading: 599cd.com/Casc...
Access SQL Seminars: 599cd.com/SQL
FREE TEMPLATE DOWNLOADS:
TechHelp Free Templates: 599cd.com/THFree
Blank Template: 599cd.com/Blank
Contact Management: 599cd.com/Cont...
Order Entry & Invoicing: 599cd.com/Invo...
More Access Templates: 599cd.com/Acce...
ADDITIONAL RESOURCES:
FREE Access Beginner Level 1: 599cd.com/Free1
$1 Access Level 2: 599cd.com/1Dollar
Donate to my Tip Jar: 599cd.com/TipJar
Get on my Mailing List: 599cd.com/YTML
Contact Me: 599cd.com/Contact
TechHelp: 599cd.com/Tech...
Consulting Help: 599cd.com/DevNet
Twitter: / learningaccess
en.wikipedia.o...
products.offic...
microsoft.com/...
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.

[@christian01234]

This is a great video! Great if you can add Fixed Assets entity so we can have Customer, Project, Budget and Assets.

[@599CD]

599cd.com/ask

[@DarrylAwesomeOwens]

Got a Video, wanna see it? Here you Go!!!!! LOL thanks for that and this!$$$

[@599CD]

Haha. Glad you like it.

[@billhuisson-ed1wc]

(15:35)How to add and append projectID if having existing data on orderT? What video should I watch first? Appreciate or your reply!❤

[@599CD]

And not exactly sure what you mean post this in the forum 599cd.com/AF

[@alykotb]

THAN YOU Professional

[@599CD]

Welcome

[@mohantrathod]

how to update data from ms access to SharePoint list

[@599CD]

599cd.com/Sharepoint