[[https://www.revelation.com/|Sign up on the Revelation Software website to have access to the most current content, and to be able to ask questions and get answers from the Revelation community]]
==== Creating a new table record from a form (OpenInsight Specific) ====
=== At 28 JUN 1999 01:54:34PM Greg Hofer wrote: ===
{{tag>"OpenInsight Specific"}}
I am wondering how to create a new table record from a form in this circumstance:
I have tables with integer keys defined as "SeqKey". When I open the form it will display a new record with the next availabe record key. Next I edit an existing record. Now how do I get the form to display a new record with the next available key again? Is there a function that I must call?
Thanks for the help.
- Greg
----
=== At 28 JUN 1999 02:02PM amcauley@sprezzatura.com onmouseover=window.status=why not click here to send me email?;return(true)", [url=http://www.sprezzatura.com" onMouseOver=window.status=Why not click here to visit our web site?';return(true)]Sprezzatura Group[/url] wrote: ===
Send a CLEAR event to the form.
amcauley@sprezzatura.com
[url=http://www.sprezzatura.com" ]Sprezzatura Group[/url]
[i]World Leaders in all things RevSoft[/i]
[img]http://www.sprezzatura.com/zz.gif[/img]
----
=== At 28 JUN 1999 02:58PM Steve C. wrote: ===
Maybe I'm looking at your question a little too simply, but after you edit the record, save the record with the key of menu . Once saved a new record with the next "SeqKey" should appear. If your problem is that you are doing this and a new record does not appear then try Andrew's suggestion.
Steve C.
----
=== At 30 JUN 1999 12:23AM Greg Hofer wrote: ===
Thanks. That was what I was looking for. I didn't know that F9 saved the record and I also needed a way to clear the form via a button.
- Greg
[[https://www.revelation.com/revweb/oecgi4p.php/O4W_HANDOFF?DESTN=O4W_RUN_FORM&INQID=NONWORKS_READ&SUMMARY=1&KEY=2BCFD32899590C238525679E00626185|View this thread on the forum...]]