I am stuck to know how to design a database for an asp.net 2.0 project.
I have a table with many fields. In addition to all the other fields (mainly text fields) I would like to keep track of 4 values: alt, sy, LaF, ord.
Any combination of these values is possible. For most records, none of these values would be applicable, meaning nothing should display.
In most queries I would like to display simply these values, seperated by a space, preferably under one heading.
..... sy ord.
..... LaF ord.
..... alt LaF
..... alt LaF ord. sy
But in my input form, I would like to use checkboxes for these fields.
I never need to make a selection on these fields, they are simply additional information to be displayed.
I fiddled with 4 boolean fields - which allowed me to set the values into the database from the form. However I could not find a way to display them the way I want to (see above).
I also fiddled with 4 different text fields, each one always using the same value in the field. e.g. FieldAlt = "alt". This allowed me to display the values the way I want - but I was unable to update the fields from checkboxes. ("String was not recognized as a valid Boolean." error messages)
Anybody has some suggestions?