Limit combo box by customer

[jwolfley]

I'm a complete noob so excuse my ignorance.

I'm looking for a simple drop down list on a form that limits the choices to foldernames that relate to the customer.

I have three tables named customer, website and orders.

I have a form named customer. I can lookup a custom and see just the domains he owns on a subform 'orders subform' that pulls info from the orders table.

What I want to do is add a combo box to the 'orders subform' that shows all the related foldernames for that customer to be select from. The foldername is a field found on the website table. From the list of foldernames if I select one it should then bind the one possible foldername for each domain. A domain can have only one foldername but a foldername can have many domains.

Each table has the primary or secondary key customerid. Both the order and the website table have a websiteid field.

So, I tried making a query that listed all foldernames and domainnames where the customerid matched and then just adding a combo box to the 'orders subform' with the rowsource pointing to the query but my drop down shows me all 235 records for all customers and not the one I'm currently looking at.

If this makes sense can anyone help?

[Rabbit]

I'm a complete noob so excuse my ignorance.

I'm looking for a simple drop down list on a form that limits the choices to foldernames that relate to the customer.

I have three tables named customer, website and orders.

I have a form named customer. I can lookup a custom and see just the domains he owns on a subform 'orders subform' that pulls info from the orders table.

What I want to do is add a combo box to the 'orders subform' that shows all the related foldernames for that customer to be select from. The foldername is a field found on the website table. From the list of foldernames if I select one it should then bind the one possible foldername for each domain. A domain can have only one foldername but a foldername can have many domains.

Each table has the primary or secondary key customerid. Both the order and the website table have a websiteid field.

So, I tried making a query that listed all foldernames and domainnames where the customerid matched and then just adding a combo box to the 'orders subform' with the rowsource pointing to the query but my drop down shows me all 235 records for all customers and not the one I'm currently looking at.

If this makes sense can anyone help?

If I understand everything correctly, you have 3 combo boxes. Customer, FolderName, and Domain.

What you want to do is have code for the After Update and On Current events. The After Update and On Current events will have the same code for their corresponding fields. The coding for each three fields will only differ slightly.

Private Sub Customer_AfterUpdate()
  Me.[FolderName].RowSource = "Select [Domain] From Orders Where [FolderName] = '" & Me.[FolderName] & "'"
End Sub
 

Hopefully you can continue from here.

[NeoPa]

This link (Example Filtering on a Form.) may help you to build the form as you want it.