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.