InfoPath Dev

I need the user to be able to enter several hypelinks when submitting the form.  My first approach was to just add a rich textbox and let them do it that way but since I am connecting to SQL2005 it appears that binding a rich text box to SQL is not an easy straight forward task.

I then tried to place them in a  repeating table and each time a new table entry was generate the same hypelink appears.

I could use a standard text box but then when the form is viewed you must cut and past the hyperlink into a browser.

I would love a suggestion on how to allow the user to reference multiple hyper links in a form that is being connected to SQL2005. 

 Thanks,

Dean 

just create a repeating table with 3 columns

1 column of type hyper link

2 and 3 columns text

in the properties of first column specify column2 as data source to link

and column 2 as data source to Display

Ok - i am a little closer.  I was not able to do as you instructed - everytime I tried to add the repeating table, infopath insisted that I bind it to repeating goup or table and since I do want to capture the informaiton I did the following: 

I have created a child table in my SQL DB and established the relationship with the parent.  The child table, "hlink", has the following fields:

hlink - varchar
description - varchar
pkey (rowguid linked to paent via relationship)
hkey (rowguid as the unique identifier for the child table)

I have added this table to the existing datasource in infopath

I have created a repeating table and linked all of the text boxes to the fields in the new datasource

If I leave the hlink text box as a "textbox" then the hyperlink is not active
If I change it to type hyperlink nothing shows up

I feel I almost have it but need a little more help --

Thanks in advance for your help 

check if this helps

I do not see anything in your post???

check the attachment(just under the title, you will see a hyper link) dswick.xsn, let me know if you are not able to get that in the above post,