Click to See Complete Forum and Search --> : About bounded forms in Access


Sharkky
July 13th, 2003, 05:18 AM
I need to rich such result: there are two tables what are displayed into form. Names of companies, their adresses and phones are shown in the first one. And for every company there is a list of leaders with their phones adresses and mails.
It's needed to reload a second table everytime when different one company is selelected in the first table.
There is a standart way to solve such problems in Access - dependent forms. But it is not appropriate for me, because, in this case, each record of general table is displayed into its own set of fields. It's impossible to display it as the table.

How to make exactly two tables?