I have a database where we store client issues and a data access page where we can view, edit and enter issues. There is a field for clinet name, account manager, account manager phone and account manager email. The Client table contains a account manager ID. I need to have the data access page autofill the account manager data based on the client name selected in the previous field. Please advise.
Start Free Trial