Combo Box Dynamic Updating

[beanie_d83]

Hi there,

I have learned how to make a combo box filter data for the next combo box but I have now added a link table to create a many to many relationship (in this case it is contacts to store chains) so a particular contact can serve more than one store.

I know why the filtering has stopped working, I just can't figure out how to fix it!

Please help!

 

[Ranman256]

The filter should still work, if you filter 1 table.
Even if there are multi companies in the list.
How are you filtering?

 

[jdraw]

If you have a Many to Many
contacts<---> storeChains
you create another table and create

Contacts---->IsContactForChain<--------StoreChains

Research Junction table or Linking Table or Bridge Table

For more focused response, please provide some code (or a copy of the database{zip format}) and instructions to get us to the area involved.

Good luck with your project.