I have 2 tables: users and colleges. The users DB contains typical user info in addition to 3 fields about the user's college: CollegeName, CollegeCity, CollegeState.
The colleges DB has 3 fields: CollegeName, CollegeCity, CollegeState.
As each entry with users is created, there is a drop-down select box where the new user indicates his college. This is created using the sub build_select_field_from_other_db. Once he indicates his college in the select box, I also want to import the CollegeCity and CollegeState fields automatically from the colleges DB. This way I can avoid mispellings and other problems.
How can I modify sub build_select_field_from_other_db and sub add_record to allow this import?
The colleges DB has 3 fields: CollegeName, CollegeCity, CollegeState.
As each entry with users is created, there is a drop-down select box where the new user indicates his college. This is created using the sub build_select_field_from_other_db. Once he indicates his college in the select box, I also want to import the CollegeCity and CollegeState fields automatically from the colleges DB. This way I can avoid mispellings and other problems.
How can I modify sub build_select_field_from_other_db and sub add_record to allow this import?