Hi
I have kept a duplicate button to duplicate the current record but I would like to know how we can make
1) few fields empty and
2) Increment a particular NID field to the next highest number present in the database. ( This particular ID field contains duplicate values too, so Autonumber is eliminated from the options). I am trying to increment that ID to (Current Highest Value in DB for NID+1)
Many Thanks.
I have kept a duplicate button to duplicate the current record but I would like to know how we can make
1) few fields empty and
2) Increment a particular NID field to the next highest number present in the database. ( This particular ID field contains duplicate values too, so Autonumber is eliminated from the options). I am trying to increment that ID to (Current Highest Value in DB for NID+1)
Many Thanks.
