InfoPath Dev

There are no Rules applied, however there is also a filter applied to make sure that when entering an new record, thev user can first select a department and next pick an employee from that specific department. The filter reads ''orgunitdesc=orgunitdesc'' or in Xpath format @OrgUnitDescr = ...

Sorry for my incomplete mail but I work with Infopath2003 and I am using Jscript. The code you suggest I guess is for VBscript is it not? anyhow, I get an error 'system not defined' I like to fill in the information only when they click the 'approve' button so I hoped I could enter a user function in the 'rules' part of the control.

Shiva, Thanks for your reply, but what do you mean by 'refresh the connection of your seconday data source'? How fo you do that? If you mean rebuild it with 'tools -> data connection ...' I already tried this without any result.

Hello, Is it possible to set a fields value with a user definied function? I have a function to get the users login name (Called: GetUserName). I would like to pass that to a field in my form. The function resides in my form code. How can this be done?

Some additional information: - Infopath 2003 - All data resides in a SQL database. - I have noticed that as soon as I change 1 field in any record and submit the change, everything shows up as it should.

I've added a secondary datasource on my form to display a employees name in stead of an employeeID. This works fine as long as I do data entry. But, if run a query, I see the employeeID en no longer the employee name. And once again, being a newbie, I have no cleu on what I did wrong.

Thanks for the reply, but I will need some time to understand your suggestion and do the conversion. Anyhow, I have a whole weekend ahead to figure out what is all about.

Hello, I made up an approval form that gets the username from the environment to put in the approriate field. But sometimes a request needs 2 approvals, so I put the approvals in a repeating table. But now, only the first record recieves the correct info. the second one always stays blank. I suppose it has to see with the use of current() but I ...

nukkumatti, I solved the problem in another way: I've added the department to the main data source. No I can populate each dropbox like I want. Anyway thanks for your help. I may become a fan of you, but I don't think I will ever become a fan of Motörhead. Cheers!

My datasources: /dfs:myFields/dfs:dataFields/d:ORGANISATIONUNIT contains information concerning the departments Fields OrgUnitNo,OrgUnitDesc,Department,Unit /dfs:myFields/dfs:dataFields/d:EMPLOYEE contains information concerning the employees Field EmployeeID, EmployeeName, OrgUnitNo My first dropdownbox is bound to the departments ...