G
Guest
I have a database based on surveys with 3 tables: account, contact, and
survey. The account and contact tables are linked by the acccount id, the
survey and account tables are also linked by account id. I have a data entry
form where the surveys can be added by selecting the account from a drop down
and then the contact from a drop down (only showing the contacts from that
account). However after you select the contact from the drop down and you
selected the incorrect account and change it - when you go to the contact
drop down - it still lists the contacts from the first account. How can you
get it to change to the currently selected account?
survey. The account and contact tables are linked by the acccount id, the
survey and account tables are also linked by account id. I have a data entry
form where the surveys can be added by selecting the account from a drop down
and then the contact from a drop down (only showing the contacts from that
account). However after you select the contact from the drop down and you
selected the incorrect account and change it - when you go to the contact
drop down - it still lists the contacts from the first account. How can you
get it to change to the currently selected account?