Forum Discussion
MichaelBarrow
7 years agoQrew Cadet
Nice response Mark! I'm just curious: Instead of needing actions to populate fields up in the parent record by making copies of what is in the child tables, why not have each bit of information from the child tables come up to the parent as a lookup field, and then have a formula field in the parent to look at each of those separate bits from each child source and choose one that's filled in and make that the value through the formula? That way, the data only lives in one place, but the weaving together can happen at the parent with formula fields working on the lookup fields.