I have a Company Table (Parent) and Contact Table (Child) and I want to have the Contact Full Name ( formula field in Contact Table) show up in the Company Table as text value instead of a report link. I have tried lookup summary and it can only show # summaries. How would I make this happen. Thank you.
I will start with the easiest situation, to float up data from the first contact record - ie the one with the lowest [Record ID#]
1. on the relationship where 1 parent has many children make a Summary of the Minimum of the Record ID. call it [Record ID# of 1st Contact]
2. Make a new relationship where 1 Child has Many Parents (ie a "reverse relationship") and use that field on the right side of the relationship.
3. Look up the Contact info to the Parent.
ThenI have an IF to see of one was flagged, and if so use it, else just take the first one.