Hi!
I have a design question for the experts here:
Currently I've got a Form with two drop down boxes that navigate you to 1 of 32 different repeating tables, all on the same schema, the main data source. Out of these 32 tables there are 14 different schemas, with different combinations of "Cannot be blank", which causes validation errors on submit for fields not currently in view. To work around, i've been told that i can put a rule in each required field? There must be an easier way?
I was thinking that instead of having all these tables on the same form, they could be broken up to different forms, and have the drop down redirect to another form, but I'm not sure how to do this, or if its even possible...But then there would be at least 15 forms, instead of one.
Any help?
James