find max id for forms

[Quoted] [Quoted] Hi, I have a form that has a field, mid denoting membership ids. This [Quoted] corresponds to an ORACLE table that has mid, name, etc. Instead of having the users find the highest mid from the database and enter the next highest one, I want the form to automatically find the largest mid and add 1 to that number and put the result into the mid field. I don't know how to do this, but I think it involves some triggering of some sort and PL/SQL, but I don't know which trigger(s) would be appropriate. Thanks.

Kevin Received on Mon Aug 06 2001 - 18:46:51 CEST