I have a table called "Text Blocks." Every record in this table contains 5 Multi-Line Text fields called "Text 1," "Text 2," "Text 3," "Text 4," and "Text 5."
When I save the record, I would like for each of those text fields to become its own record in a table called "Text Entries."
HOWEVER, I suspect that method won't work in my case, because when this app goes into production, each Multi-Line text field is likely to contain thousands of characters, and I bet passing that data in a URL variable will probably break something.
So I'm wondering if there's a better way to pass those Multi-Line Text fields to the code page. I'm thinking maybe I could do something with XML, but I've been racking my brain all day and can't seem to come up with anything. Can anyone help?