Auto-enter info in a field depending on an other field
The "Captain" field on the form is a pop up menu showing the values from the Crew table.
The phone, email and Fax are entirely part of the Vessel table.
I want those 3 fields to copy the information from the captain's information on the crew table if selected, or be blank if nothing is. I really want it to COPY, not just refer to another table, and be able to edit it anytime.
I would greatly appreciate if you could help me out! Thanks!