From the course: Access: Building a Sales Database

Unlock the full course today

Join today to access over 22,700 courses taught by industry experts or purchase this course individually.

Adding related table-based controls to a form

Adding related table-based controls to a form - Microsoft Access Tutorial

From the course: Access: Building a Sales Database

Start my 1-month free trial

Adding related table-based controls to a form

“

- [Narrator] Combo boxes are controls that can display a list of values from another table. Like a list of vendors for a particular product on our products table, or a list of orders placed by a given customer. We can also use it to simplify data entry into a field where there's just a very short fixed list of things we will accept in that field. It could be the communication types that we've sent to a customer. It could be the status of customers. But, the most powerful way to use the combo box is to use it to relate records between tables where a relationship exists. Now, I'm gonna demonstrate that here on the orders form. I'm gonna add a combo box that allows me to select a name from our new sales rep table. I've added a sales rep table because I realize that I don't always close all the sales. Sometimes I have help and I want to keep track of which sales rep helped me out. Because of course I'd pay them a commission. So, I wanna keep track of who helped me out. So, I just wanna…

Contents