 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / General MS InfoPath Questions / June 2005Query results all the info in Database, even the one not needed!
Hi, I created an infopath form connected to the SQL database.This form updates and searches the database.This works great.But, when i try to search the database with specific field.Eg Skills, i get all the records, even the one which doesn't contain the specified skill. the ones which contain the specified skill name has the skill name displayed and the other ones have skill's feild empty (Bt shows the other info like name, address, experience). How can i make this unwanted table of results invisible when searched? Appreciate any kind of help. Also, i forgot to mention that Skill information is coming from table Skills, which is a secondary data source.. Thanks! Use filtering - for example, if you are displaying your search results in a repeating table, double click on the repeating table - this will take you to repeating table properties; select the Display tab; click on Filtering, and configure your filter to only display records whose skill = selectedSkill. Good luck, Alex @ Microsoft > Also, i forgot to mention that Skill information is coming from table > Skills, > which is a secondary data source.. > Thanks! ALex, Thanks! This helped.. |
Reply to this Message |
 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.