I have list with some fields in that, and in one field I can enter a value then a number of new fields must be populated. The number of new fields created must be equal to the value specified Columns to be iterated in the list based on the value specified 1.Department section 2.Name of employee 3.employee Designation 4.shift time Drop down with values(morning, noon, night) 5.Remarks if any
If you are using InfoPath, you can create a data connection to an XML file, and use that to set the valid values based off the original field.
For example, assuming I'm understanding you right, I could set up a field called "State," and then, based off the State, populate the "Cities" field with the appropriate values.
If this is the approach that you would like to use, let me know and I'll provide more in-depth details.