ligical Q..

[dixieee]

ok i figured it out..now i have a table that stores the Username of the
employees to give other info when infopath automatically fills the username
field as they log-on (as a secondary source). what i can't figure now is a
logical issue. how shall i make it that info about the employee is displayed
in the fields coming from the table?

i get the login and domain for the user but when i put the fields from the
database i get all the names again..

plz help..thanx

 

[dixieee]

ok ok i got the way but i still can't figure the Query to use. anyone plz?

 

[Adam Harding]

dixieee

no query just set the fields you want to populate equal to the field from
your secndary datasource and then click the filter button and specify where
username in the secondary datasource = USERNAME DISPLAYED IN THE FORM FIELD.


Ie USERNAME field is populated on opening the form the field is called
EmailAddress its default value is displayed from a secondary data source
called UserDetailsSecondary column name EmailAddressSecondary.

It would have a filter on it saying Where UsernameSecondary is equal to
USERNAME.

Do this for all the other fields and it is all sorted. This is provided the
secondary data source contains the information you need. If not you need to
find it first.

I hope this helps

Cheers Adam