Return the value of a specific related record

[danilevel]

I have a database set up with Customer records relating to multiple Contacts for that customer. I am having trouble creating a calculation to return a value from a specific related contact (one among many) based on its contact ID.

For example, each Customer has a default billing contact, which is recorded by its ID in the customer record. What calculation would return the email address of the default billing contact?

The calculation I'm currently using, based on case ( ), is not returning the value from the correct entry:

Case ( billToContactID = customerContacts::contactID ; customerContacts::email )

Thank you,

Dan

[comment]

IMHO, it would be best to define another relationship between the two tables, based on matching:

Customers::BillToContactID = Contacts 2::ContactID

Then you can use fields from Contacts 2 directly, with no calculation required.

[danilevel]

Thank you!