Hi!  I come from MS access and I want to build in creator.  I have a Registration App I want to make.  The main table is called Registrations and I have a subform called RegProgress where the user can indicate the progress by selecting one of 6 steps.  Those steps each have a value in a form called Progress Steps.   

I want to have a report that shows me all the registrations and how far they are along but I can't get the max number from progress steps, which is a field in RegProgress to update.  Even when I manually populated the Step Value in RegProgress, the workflow would not find them to get a maximum value, it would return a 0.

I spent hours and hours with ChatGPT but I keep going in circles and getting nowhere.  

Am I attacking this all wrong?   Any advice would be welcomed.