InfoPath Dev

Thanks for the reply.  How do you check what groups a user id a member of from within Infopath? 

thanks for the reply. I have already tried displaying data in a repeating table. It again shows me last 23 records only

Jimmy, Thank you so much for your response.  I want to allow only Numbers in a text field. The issue is if the users enters alphanumeric(e.g 100k), I will get a runtime error, due to the non-numeric value in a evaluate expression.    I am using JScript to calculate a %.   I don't want to allow user to ...

Qdabra's AD Web Service will allow you to retrieve the alias of any user's manager, which you can then use to retrieve the manager's e-mail address. The web service also provides several other useful features and I recommend checking it out if you do a lot of work involving active directory.

If you are just looking up data, secondary data connections than they would probably be faster is they were SP lists, rather than access tables. However if they are remote, and since you cannot query a secondary source unless it is a web service, then it may not make too much of a difference.  If you could have this data local to the users ...

If you display the secondary data in a repeating table as a test, rather than the drop down, do you see all of the rows? That would tell you if it is a dropdown issue or the data connection.

I would use a substring function to harvest the current year from today's date. Then use concatenate to create your file name. That way on 1/1 it will automatically take the new year.

Have the permissions on the UDC container or site changed? Have you tried with Admin credentials?

I do not think the AD Web Service has a setting for this unless you restricted the domain. You could contact Qdabra support directly and ask. However on the server where the web service is installed you may be able to set the DNS so that it prefers one DC over and another.  This is just a guess, but would be where I would look.

Hey Duane. This looks like an issue with your primary key in your child tables, specifically Leave_Data. You either need to generate the correct unique ID in your form so that it does not duplicate or have Identitiy on in SQL so that one is generated automatically. Your submit is blocked since the new Leave-Data record either does not have a ID ...