AnsweredAssumed Answered

ExecuteSQL to generate a list of return separated fields?

Question asked by ezeitgeist on Oct 4, 2017
Latest reply on Oct 4, 2017 by philmodjunk

Does anyone have a link to a tutorial or a simple explanation of how to create a return separated list of a certain field from a table based on matching fields from another table?

 

SETUP:

I have a Projects table with Leader_1 and Leader_2 and Assistant_1 and Associate_1 fields with drop-downs.

The drop-downs select Contacts::Serial_ID (all of them are from the same Contacts table).

 

GOAL:

I would like to use ExecuteSQL (I believe this is the best route, from my understanding) to fill a Contacts::Current_Projects field with a few fields from Projects:: for each Contact.

 

How do I do that?

 

Or would it be better to use a TO and a portal?

I'm not sure how to filter/associate the Contacts::Serial_ID with all the Projects table possible fields it could be in.

Outcomes