Forms with Database

T

Tyampoo

Hi all,

I am writing with high hopes.

I am designing a travel request form based on database (SQL Server). The
database has 10 tables (as of now). TravelRequest is the master table with
TravelRequestId as its primary key. It is set as an identity. When I created
the form (dragged "datafields" into a layout table cell), travelRequestId was
also shown to be filled.
Now my questions are:
How would I deal with identity, i cannot give value as sql server will do it
for me when any value is entered.
Also I don't see "Submit" under "File" menu.

Any help is appreciated!

Thank you,
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Open form 0
Users cannot access Database when form loads. 0
InfoPath storing identity (autonumber) value in the form 3
Unrecognized database format 'S:\xxx.accdb' (Microsoft Jet Database Engine) 0
Access 2013: Form problem in reading data tables; relationship one-to-one 0
Sumitting Forms connected to a database. Help!!! 3
HOWTO query by passing a parameter from Infopath 20007 to a MicrosoftAccess 2007 database? 0
Infopath form Inserts only but no updates 0

Top