Filter Form Based on Combobox

[Ian-W-]

Stuck.....



Ive been given the task to create a database for my company.

I have to create a database to handle rental furniture, i have the basic tables sorted but im stuck because I know what i want to do but dont know what it is called

I have a table named "Customers", this holds there name and address details.

I then have another table named rentals, this is where you select what each customer is renting.

What I want to do is select the customer from a drop down menu (I can do that ) but i want the customers details to fiter through the boxes underneath, is this cascading?

I know this is proberly really simple but im more technically minded and im not a big fan of db's.

Any help much appreciated

Ian

 

[dcx693]

i want the customers details to fiter through the boxes underneath

What exactly do you mean there? You want to display only records belonging to that customer? You want to display the customer details, but not the orders?

 

[Ian-W-]

sorry, I didnt make that very clear,

Lets say I have 6 boxes

Customer Name .............. (this is the drop down box)

House Number ................

Address Line 1 ................

Address Line 2 ................

Post Code ................

Tel No ................

I want the list of customers that are in the customers table to be listed in the customer name drop down box, when a customer name is selected then all the other boxes i.e house number etc are populated with the data to match the name.

Is that a bit clearer? Sorry, im not up on database terminology yet

 

[Uncle Gizmo]

Have a look at Item 7, the "One Form Example" here

 

[Ian-W-]

Thats like what im after! Now just to work out how it was done.

Cheers

Ian