I will try to be as brief and clear as I can, and hope it is enough for someone to read my mind.

This video clip shows I have made some progress. I am getting the day of week returned in it's numeric value now.

The problem is that is not the way I need it to make the form function. I have 2 different tables. The client table has a section for each client with checkboxes checked for the days they are schedule to be there. When a staff member enters the date they are doing attendance for I would like the list of clients to display only those who are scheduled to be there according to the client table that has their schedule.

My question is what type of field would I use as a variable to pull from the client table based on the digit that is in place for the day of week?

The field type in the video would even work I think if there were a way for the form to automatically choose the only option that appears in that box. The code listed below is what I have but I know I need more:

   

    
 show RealWeekDay;
      

       
      
      

       
       
       RealWeekDay:ui.add(input.Date_field.getDayOfWeek());
       
      
      

       
       
       RealWeekDay:ui.add(input.Day);