Seems a doubtful approach, is there some reason they are not related records, one record per line?
That is a good question.
The "record " in this case is a medical history given by a particular patient on a particular date and the numeric list I am looking to insert in the history is a plan of action for the visit. Since the visit history is stored, I questioned the benifit of storing each line item in the plan as a record related to the patient visit at the cost of increasing the size of the file.
In this instance, I guess I am looking to simplify data entry with the pull-down pick list as well as format the entry as a numeric list while keeping things as efficient as possible. Any thoughts would be more than welcome.
I don't buy the file size story.
If you just did what databases do; display normalized related data; you'd be done now.
You never intend to report on or discover anything about the related data, across a patient's history or across multiple patients?
You may want to look at using an "Get ( TriggerKeystroke )" function.
Re: "I am looking to simplify data entry"
What could be simpler than adding lines in a portal? That's what you'd be doing if you followed Bruce's advice.
Thanks for all the great advice. I will try using a related record with portal.