I want to have people add data for each quarter to columns in a horizontal repeating table. My heading row contains a dropdown for the user to pick the Quarter, how can force the user to pick the next sequential quarter? i.e, if the form already contains Q1 data, then next column should be Q2 and they should not be allowed to pick Q3 unless Q2 is present.
TIA
Dean