It was in my original response but I'll try to restate it in an easier/detailed fashion.
You'll need to add a SEARCH action below the insert. In this new search action, drag the serial number field into the 'Select Columns' box of the 'Select' tab. Then click on the 'Criteria' tab and drag the 'recordid' into it. The operator will remain as '=' and for the 'Value' column, use <@ACTIONRESULT NAME=nameofinsertactiongoeshere NUM=1>. An easy method of getting this tag is to click in the value column, then hold down the Apple key (I think, or it might be Option) and click to get a context sensitive menu that will have 'Insert Meta Tag'. Select this, change the category pull-down to 'Action Result Item', choose the name of the Insert action from the 'Action' pull-down and enter '1' in the 'Item Number' field. This method works anywhere you want to add <@ACTIONRESULT ...> tags as well as <@ARG ...> and current date, time, and timestamps tags. To display the returned value, click on the 'Results HTML' attribute for the search action and create your response page there. When you want to display the serial number, use <@ROWS><@COLUMN NAME='layout_0.nameofserialnumberfield'></@ROWS>. To make it easier, the <@COLUMN ...> tag will be found at the top of the snippets pallet, inside 'Column Snippets' so you can drag it into the Results HTML window rather than having to type it out. Hope this helps, Steve Smith Skadt Information Solutions Office: (519) 624-4388 GTA: (416) 606-3885 Fax: (519) 624-3353 Cell: (416) 606-3885 Email: [EMAIL PROTECTED] Web: http://www.skadt.com > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED]]On Behalf Of Paul Hart > Sent: October 11, 2002 4:56 AM > To: Multiple recipients of list witango-talk > Subject: Re: Witango-Talk: ID field in response to new record > > > --On Thursday, October 10, 2002 5:09 pm +0100 Nicholas Froome > <[EMAIL PROTECTED]> wrote: > > > Beverly > > > > > >> I'm assuming that Tango gets the ID and that's what you see in COL 1. > > > > I didn't think that Tango returned the Record ID, but I just checked - > > and it does > > > > I didn't know it was accessible from within Filemaker with a Status() > > command, though it doesn't surprise me > > > > I bow, as ever, to your superior knowledge of all things Filemaker! > > According to the Manual Tango needs to know this Record ID to > find out what > record it just saved so it can then get my serial number from the newly > created record to display in the responce. My problems is how I find out > the Record ID and use it to display the new serial number. > > Someone mentioned using a global field but globals work in a funny way > which means they are lost when a client logs out of the server, so won't > work for what I want to do. > > Regards Paul. > > --------------------------------------------------------------- > Paul Hart > IT Manager > Medical Research Council > Laboratory of Molecular Biology > Hills Road, Cambridge, CB2 2QH. England. > > Tel: +44 (0)1223 245133/DDI 402394 > Mobile: 07867 500598 > Fax: +44 (0)1223 213556 > > email: [EMAIL PROTECTED] > http://www2.mrc-lmb.cam.ac.uk > http://www2.mrc-lmb.cam.ac.uk/personal/pdh/Go_For_it.html > --------------------------------------------------------------- > ________________________________________________________________________ > TO UNSUBSCRIBE: send a plain text/US ASCII email to [EMAIL PROTECTED] > with unsubscribe witango-talk in the message body > ________________________________________________________________________ TO UNSUBSCRIBE: send a plain text/US ASCII email to [EMAIL PROTECTED] with unsubscribe witango-talk in the message body
