D
DeanT
I have a table (Complaints) which has a ‘state’ field and ‘authority_addr’
and ‘authority-city’ fields in it. I also have a table(AuthTable) with state
and corresponding auth address records. i.e.,
AL 10 main Street Birmingham
MA 20 Blue st Boston
My problem: When I enter the state in the state field of the Complaint form
how do I automatically populate the authority_addr and authority_city based
on the matching state in the AuthTable? I am fairly new to programming.
Thanks for any help. Dean
and ‘authority-city’ fields in it. I also have a table(AuthTable) with state
and corresponding auth address records. i.e.,
AL 10 main Street Birmingham
MA 20 Blue st Boston
My problem: When I enter the state in the state field of the Complaint form
how do I automatically populate the authority_addr and authority_city based
on the matching state in the AuthTable? I am fairly new to programming.
Thanks for any help. Dean