Can't Import field from Parent Table to Child Table

Question

I have two tables with the relationship Activities->Statuses. There are several fields that are on the Statuses table that I need to import onto a report in the Activities table, but then there are fields I need to add to the Statuses table that I'll need to import into the report that I'm creating as well. See the attached screenshot of the Activities report with all the fields I need. The fields I need imported are Status Report Narrative, Final Report Narrative (both need to be added to the Statuses table first), Benefit/Outcome, and Clean Water Act Relevance (these 2 already in Statuses table). I've already got the 2 Link fields importing from a separate table- Documents. The Statuses report link is embedded in the Activities main form- this is where users will log edits to those fields.

------------------------------
Bethany Dickey
------------------------------

------------------------------Bethany Dickey------------------------------

MarkShnierYou · Answer

So re you saying that 1 Activity has many Statuses and that you simply want to float up the content of some Text fields up to the parent?Have you tried using the Combined text summary fields on the relationship to summarize the text fields?If that is all you need and you don't like the bubble appearance of the result, you can create a formula text field like this to make them look better.SearchAndReplace([My Text Concatenation Field]," ; ","
")------------------------------Mark Shnier (YQC)Quick Base Solution ProviderYour Quick Base Coachhttp://QuickBaseCoach.commark.shnier@gmail.com------------------------------

Sign up

Login to the community