AnsweredAssumed Answered

Auto-enter info in a field depending on an other field

Question asked by ChloeF on Sep 19, 2011
Latest reply on Sep 20, 2011 by philmodjunk

Title

Auto-enter info in a field depending on an other field

Post

Here is part of the form from the "Vessel" table with my issue: form

And here is part of the relationship table: Relationship

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!

Outcomes