Is the answer to this not the same as the solution posted by Witango Support an hour or two ago to a similar issue....
This is more accurate and reliable than doing a search action. Witango Support wrote.... You can also use a Direct DBMS containing: select <@literal @@identity> immediately after the insert action. This will result in one record being returned which will be the id of the record you have just inserted (<@ASSIGN request$Record_ID "@@request$ResultSet[1,1]">) You will need to have both the insert action and the Direct DBMS within a Begin/End Transaction for this to work. --- Campbell Steve <[EMAIL PROTECTED]> wrote: > Hello All > > Simple problem here..and I know that it's been > talked about, fixed and even > probably talked about over and over again on this > list. > > I am doing a simple insert action into a table in my > database. After the > Insert action of course WiTango gives you the > "Record added successfully" > default text. At that point, I want to somehow use > the "record key" that > Access so wonderfully auto assigns every record that > is inserted into a > table , I want to somehow pull that out and paste > that in under the default > text that WiTango spits out. > > > I suppose I can do another Search action, but I was > wondering if anyone has > done it by an easier and less complicated way > > > Thanks > > Steve > Forerunners > > > IIS > WiTango APP Server T2K > WiTango Dev Studio T2K > Access Database > > > ________________________________________________________________________ > TO UNSUBSCRIBE: Go to http://www.witango.com/maillist.taf __________________________________ Do you Yahoo!? Yahoo! SiteBuilder - Free, easy-to-use web site design software http://sitebuilder.yahoo.com ________________________________________________________________________ TO UNSUBSCRIBE: Go to http://www.witango.com/maillist.taf
