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 / May 2007

Tip: Looking for answers? Try searching our database.

Using a new record ID before an item is submitted

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
DarrylGould@googlemail.com - 14 May 2007 15:22 GMT
Hello

I have an IP form which links to a SQL database.  I want to make a
field equal to the records ID, i.e. ID = fieldA, however, as IP
doesn't know the ID of the record until the form is submitted to the
database, how can I make fieldA equal to it?

Any ideas
Thanks
Darryl
Art - 16 May 2007 02:56 GMT
does the record exist in the SQL table or is it a new record being created?

If a new record you can query the database and look at the last ID but what
if two forms are opened at the same time?

In reality, I do not think it can be done.

> Hello
>
[quoted text clipped - 6 lines]
> Thanks
> Darryl
 
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.