InfoPath Dev

 Hello!

 Im very interessted to solve the following problem:

I have a Database (*.mdb) with two fields.

Username and Name.

 Furhtermore a Infopath form with two fields.

Username ( fieldname: UsernameAusSystem; value: userName())

Name  (fieldname: NamenAusDB; value: @Name->get the Name field from the Dataconnection)

Database and Infopath Form are connected with a simple dataconnection.

The goal is  compare the Username field from Infopath with the Username field from the DB

and if its machted then put  the value from the Database Name field into Infopath Name field.

The following SQL-Code doesnt work:

select [ID],[Usernamen],[Name] from [UsernameAusDB] as [UsernameAusDB]
where [Usernamen] like [UsernameAusSystem]

I think it is a little problem, if i write:

 select [ID],[Usernamen],[Name] from [UsernameAusDB] as [UsernameAusDB]
where [Usernamen] like "JohnSmith"

and JohnSmith is a value in the database, it works.

Can anybody write me the write syntax?

 Regards

Philipp

Hi -- are you talking about using the a form field in your form as part of the SQL query in your data connection? If so, I'm afraid your choices are code or web services (we sell a great one that does this, and you can get a free trial here).

 Thank you Hilary but I found another way to solve this problem,

I get the information from LDAP.

http://msdn.microsoft.com/en-us/library/bb952744.aspx#ip2007GettingUserInformationActiveDirectory_ReadIt

regards

Philipp