Referencing entities is a great capability of Drupal but gives me headaches.
I have three content types: Client, Contact and Job ticket.
Clients are companies with whom I conduct business. Contacts are contact persons within these companies. The Contact content type has a reference field referencing their company's node. Job tickets are tickets for jobs these companies hire me to do for them. In this content type I have two reference fields: one for the Client and one for the Contact.
This is my problem: In the Job Ticket I have a select list field that needs to be populated with the address (or addresses, since there can be multiple values for the Address field in the Client content type) of the client when I select the client in the reference field select list. How can I do this automatically.
I tried the Field Reference module but I can't get it to work, and it would give me ALL the addresses from ALL the client nodes. I only need the one(s) from the previously selected client.
Thanks in advance.