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?
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).
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.