AnsweredAssumed Answered

Create a value list from 2 different tables

Question asked by noushie on Jul 19, 2012
Latest reply on Sep 12, 2012 by comment

I Know that I'm missing something simple, but I cannot seem to find an example that deals with this. I would like to be able to create a list of names compiled from 2 different tables. It woudl be great to be able to create a valu elist based on 2 different tables, and I'm sure there is a way to do this, but I just cannot do it.

Eg. I have a table that has the main contact (ie Primary_Contact's FirstName_Surname). I then have a table joined to this table which details some additional contacts (Additional_Contact First& Surname). There are multiple additional Contacts connected to the Primary Contact. I want to be able to create a list of names that includes the Primary Contact and all of the additional Contacts connect to them. Is there a way to create a calculation field that creates a list of these?

Outcomes