There is nothing stopping me from saving another inspection later. That isn't the problem. My user creates this inspection, and the inspection is then saved to the SQL tables. A form is then generated from these Inspections for factory operators to fill out later. For example, if there are two inspection points, then two drop down options on the form will be generated, one for each point. The problem is saving the data from those dropdowns, because those dropdowns are generated from the inspection, created by another user, so I don't have a SQL table that can map to the data from the dropdowns - since a user created those fields, not me.

Here are the constraints that I am facing Can only use SQL Server Cannot use Entity Framework or Dapper Can only use .NET Framework (can't use any Python or JS) What I am working on is a project for a factory I work for is that I am digitizing our quality inspections, of which there are numerous. The first step is that I created some models to that are used to create a Quality Inspection plan, which are here below:

public class QualityInspection
{
public int Id;
public string Name;
public double Frequency;
public List Sections;
}

public class InspectionSection
{
public int Id;
public int InspectionId;
public string Name;
public List Points;
}

public class InspectionPoint
{
public int Id;
public int SectionId;
public string Name;
public List InspectionResults;
}

public class NonConformance
{
public int Id;
public string Name;
public List Level;
}

public enum NonConformanceLevel
{
None,
Minor,
Major
}

This is an example of a dummy inspections plan:

QualityInspection inspection = new QualityInspection()
{
Id = 1,
Name = "FgInspection",
Frequency = 2,
Sections.AddRange(new[]
{
new InspectionSection() {
Id = 1,
InspectionId = 1,
Name = "Packaging",
Points.AddRange(new[]
{
new InspectionPoint()
{
Id = 1,
SectionId = 1,
Name = "Seals",
InspectionResults.AddRange(new[]
{
new NonConformance() {Id = 1, Name = "Torn", Level = NonConformanceLevel.Minor},
new NonConformance() {Id = 2, Name = "None", Level = NonConformanceLevel.None})
});
},
new InspectionPoint()
{
Id = 2,
SectionId = 1,
Name = "Dates",
InspectionResults.AddRange(new[]
{
new NonConformance() {Id = 3, Name = "Smudged", Level = NonConformanceLevel.Minor},