I have a one to many relationship where the parent table is "projects" and the child table is "tasks". I created summary fields to show the minimum and maximum related task on each record for the projects table.
I would like to show another field from the tasks table on the projects form for matching tasks. Right now I only see the record ID# of the min/max related task and I don't see an option to display other fields from the tasks table.
I was wondering if there was a way to do this, similar to an index match function for excel. Thanks.