I have an Access database that I am using as the backend with ASP.Net
The Access DB contains fields such as "step#" "instructions" "date"
The problem I am having is some of the instructions contain data that not text. Some "instructions" will have yes/no, some will have 1 textbox, some will have 3 textboxes within that record to be filled out. How can I make this in Access and retrieve this in ASP.net? I guess you may call it a table within a table???
I was thinking that i would need to make a separate table that has those conditions (y/n, textbox, textarea, etc). My problem was linking and associating them. Like how would step 1 in table main know that it requires a textbox, how would step 2 know that it requires a fill in table with 4 cols and 8 rows for data, how would step know know it requires a checkbox, etc? The date I am working with is a complete mess, i am now getting the structure correct, but this table has the most problems, because it requires some input. I hope i am making sense explaining this.