I have Parent < Child tables, and Child contains field we'll call 'Child info'.
I need fields in the Parent to list info from all Child records (up to 10, but almost always less--or none), without repeating duplicate info if all Child records have already been 'looked at'. In other words, if there are 4 Child records, Parent lookup fields 6-10 should be blank.
I understand I'll create 10 reverse-lookup relationships from Child to Parent, and 10 fields in Parent, each of which will display info from one Child record.
- a way to jump from one Child record to the next, so info from all Children gets listed
- a way for the lookup fields to be blank if all Child records have already been pulled
Is there a way to do this?