General

Re: Repeating Tables - Duplicating data from first row.

Hilary Stoupa — Thu, 09 Oct 2008 16:08:51 GMT

When you click "verify this formula" you don't get any errors?

Are you using IP2003 or 2007? I've found that the behavior with current() is not always consistent between the two. Another thing you can try is using a rule instead of a default value. If you are using IP 2007, I think it will generally add current() for you on rules on repeating fields.

Re: Repeating Tables - Duplicating data from first row.

jtownson — Thu, 09 Oct 2008 16:04:31 GMT

Thanks Hilary...tried that and now the login on 2nd row is correct but then all other rows after that are the same as the 2nd?

Infopath changed your statement to this; @LOGINID[@DISPLAY_NAME = current()/../CustomerName]

not sure if that is an issue.

Thanks

Re: Repeating Tables - Duplicating data from first row.

Hilary Stoupa — Thu, 09 Oct 2008 15:50:53 GMT

Hi,

You probably need to add current() to your default value for login:

@LOGINID[@DISPLAY_NAME = current()/CustomerName]

Repeating Tables - Duplicating data from first row.

jtownson — Thu, 09 Oct 2008 15:40:07 GMT

Hi all,

Created a Repeating Table with two colums - Colum 1= Customer Name, Colum 2 = Login ID. Customer Name is a drop down listed connected to a sql server database and when a name is selected it puts the login ID in colum2 using a filter. However when using the form and adding more rows even though I select a different Customer Name on say the 2nd or 3rd row the LoginID is always that of the first line. Is there anyway round this?

Default Value for login name is this; @LOGINID[@DISPLAY_NAME = CustomerName]

Thanks all