Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / General MS InfoPath Questions / April 2006

Tip: Looking for answers? Try searching our database.

ligical Q..

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
dixieee - 17 Apr 2006 10:06 GMT
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 - 17 Apr 2006 14:37 GMT
ok ok i got the way but i still can't figure the Query to use. anyone plz?
Adam Harding - 18 Apr 2006 11:55 GMT
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

> ok ok i got the way but i still can't figure the Query to use. anyone plz?
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.