I am kind of new to access and learning...
I have got a form where I have a combo box where names of companies are listed. there is another combo box where its branches are listed.
So, One table is holding the company names only. 2nd table is named after that company and have all the branches listed inside. 3rd table the same way and so on and so forth.
I want to link two combo boxes together in a way that if a company name is selected. It will first see the name of the company selected and depending on that will go to its specific table and only show the branches listed inside.
Can anyone help me get this done? Thanks
I have got a form where I have a combo box where names of companies are listed. there is another combo box where its branches are listed.
So, One table is holding the company names only. 2nd table is named after that company and have all the branches listed inside. 3rd table the same way and so on and so forth.
I want to link two combo boxes together in a way that if a company name is selected. It will first see the name of the company selected and depending on that will go to its specific table and only show the branches listed inside.
Can anyone help me get this done? Thanks