Content over a number of pages

[jlynch1]

i have a lot of information i want to store in a database relating to say for example a course taught in a college.

i want to store general information about the course but there is a lot of information so it will need to be spread out over a number of pages. Can i store all this information in a single memo field in access and then split it up over a number of pages.

The only problem with having seperate fields for each heading in general info is that not every course has information under each heading.

what is the best way to store this information in a database ?

 

[modalman]

From my experience its best to try and create as many commonly used fields as poss (you never know when you may want to search on a particular field)
However if you have a lot of unique fields for your courses then you could store them all in a memo field. Delimit them with a unique character or characters and of course include the name of the field along with the value. eg: "MyFieldName|MyFieldValue|" where "|"=delimeter

To do this over many pages you will need the same form fields on each page. The ones that arent filled on by the user on the page are to be hidden fields. Then the whole form is passed to the next page and on the last page all the fields should have a value.

Hope thats what you are after ASCII silly question, get a silly ANSI

 

[jlynch1]

what is the value MyFieldValue that is stored along with the fieldname and the content used for.

instead of using forms could i just use query strings ?

 

[modalman]

MyFieldValue is the content of the textbox/textarea whereas MyFieldName is the name of the textbox/textarea.

I think querystrings have a limit of 256 chars so you would be safer using form submission as it sounds like you could be passing a lot of data ASCII silly question, get a silly ANSI