I want to develop employee bio data form. there is section in the form that is a repeating section. I want a situation where the employee can go back to edit the information. Attached is the screenshot of the form look like on paper.
You could have 3 Lists. 1 for the main details, 1 for the Education details and another for the previous employment details.
You can have an EmployeeID column in the 2nd and 3rd lists that stores the ID from the 1st list.
When you want to store the Education or Previous Employment details to List2 & List3 you will patch all the necessary data along with the EmployeeID field which is the ID for that same Employee in List1. Probably this diagram will explain it better.
@CNT, how can I achieve it without using flat structure. I want the user to have the right to go back and edit the items in the repeating section of the form.
@whykay1029 You have 2 repeating sections. If the number of entries in them is fixed, a flat structure is fine (provided the requirements do not change in the future).
Having a flat structure (just 1 share point list) is not generally advisable for repeating data. You could rather have 3 Lists. 1 for the main details, 1 for the Education details and another for the previous employment details. You can have an EmployeeID column in the 2nd and 3rd lists that stores the ID from the 1st list.
Please consider which way you want to go. Either way give me a buzz if you need more help!
yes, A flat structure where everything goes to a sharepoint list. also have the ability to edit it.
@whykay1029 What data structure do you have in your database to store this information? Is it a flat structure where everything goes into one table/list or you have a normalised structure?
WarrenBelz
89
Most Valuable Professional
MS.Ragavendar
58
Michael E. Gernaey
42
Super User 2025 Season 1