how to retrieve and insert new records within one view in the form

[Victor Lung]

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

 

[Jerry Thomas [MSFT]]

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?

--
Jerry Thomas[MSFT]
<[email protected]>
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.

 

[Victor Lung]

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.

How will you be storing the data?
Will this stay in XML forms or will you be linked to a data base?

--
Jerry Thomas[MSFT]
<[email protected]>
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:
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

 

[Jerry Thomas [MSFT]]

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.


--
Jerry Thomas[MSFT]
<[email protected]>
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.

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.

How will you be storing the data?
Will this stay in XML forms or will you be linked to a data base?

--
Jerry Thomas[MSFT]
<[email protected]>
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:
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