Data Gets "pushed" together in text box

N

NikV

I have a question. I have a text box in my InfoPath template. The text box
will store Milestone dates. For example the data will look like the below
when the user enters it in:

9/10/05 Project Kickoff Day
9/15/05 Project Funding Finalized
10/12/05 Ran into some Data problems

After hitting submit in the template, the data will be stored in a database.
The database has a trigger which will write an XML file. The XML file is
used to populate the text boxes for additional edits in the future. My
question is how do I keep the data looking like the above when it's reading
from the XML file. The data gets "pushed" and "word wrap" all together.
Hope this makes sense. Thanks in advance.
 
F

Franck Dauché

Hi,

On the data entry side, it is cleaner to have 2 separate fieds (1 for date,
1 for description). Then if you need it, in your xml doc, you can create a
3rd node that will hold field1.text + " " + field2.text. You can use that
field on a print view for example.

Is that what you are after?

Franck Dauché
 
N

NikV

Franck;
The quanity of dates and description varies among employees. One employee
can have one date and description while the other can have 20.

What route do you recommend me to take? Also, if I set up the date and
description data entry box in two seperate fields, does that mean I need to
set up two seperate fields in the database to house it? Thanks!
 
F

Franck Dauché

Yes you would need 2 separate fields in your schema. You can build a
repeating table around these 2 fields (repeating folder in your schema) so
that you can add as many sets as you want at runtime.

Franck Dauché
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top