 |
 | 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 / September 2004how to retrieve and insert new records within one view in the form
dear all, I want to create a absent request form with the following requirements: 1. at the top of the form, user enter his name, the form can show his information (dept, tel, email) automatically from the employee table in database. 2. at the lower part of the form, user can enter the absence details, this information would be inserted into the absence_detail table in database. Can i include the above retrieve (but not updatable) and insert functions within one view in InfoPath? Thx a lot You should beable to do this without too much trouble. How will you be storing the data? Will this stay in XML forms or will you be linked to a data base?  SignatureJerry Thomas[MSFT] <Jerryth@online.microsoft.com> Microsoft Office InfoPath --------------------------------------- This posting is provided "As Is" with no warranties, and confers no rights. Use of any included script sample are subject to the terms specified at http://www.microsoft.com/info/cpyright.htm. Please do not send email directly to this alias. This alias is for newsgroup purposes only. > dear all, > I want to create a absent request form with the following requirements: [quoted text clipped - 8 lines] > > Thx a lot Really thx Jerry. > How will you be storing the data? It will be linked to the database (SQL server). > Will this stay in XML forms or will you be linked to a data base? In what purpose and when would I store data in XML forms? Is it when the database is offline? Thx again. > You should beable to do this without too much trouble. > [quoted text clipped - 13 lines] > > > > Thx a lot Your primary data link would be to the attendance table. Then create a secondary link to the employee data table. Secondary data links are Read Only so that would protect that info from inadvertant change. The query would be based on employee ID. SignatureJerry Thomas[MSFT] <Jerryth@online.microsoft.com> Microsoft Office InfoPath --------------------------------------- This posting is provided "As Is" with no warranties, and confers no rights. Use of any included script sample are subject to the terms specified at http://www.microsoft.com/info/cpyright.htm. Please do not send email directly to this alias. This alias is for newsgroup purposes only. > Really thx Jerry. > [quoted text clipped - 24 lines] > > > > > > Thx a lot |
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.