I have created a table (Design Status) which is one to many with projects table This table is intended to allow our planners to document various design stages a plan goes through. On the other hand construction guys want to have a real time design status in their form on the last status achieved.
I thought I could use the summary field option to report back the last design status but that unfortunately works only with numerical values. Either my approach is wrong or I have to have some support from you so that I could report the text field of last record in the parent table. Any chance we could report a field in the last record into the parent form.