View Single Post
  #1  
Old 20th April 2005, 15:41
kogelman kogelman is offline
Junior Member
 
Join Date: Jul 2003
Location: Holland
Posts: 16
kogelman is on a distinguished road
Baan: Baan IVc4 & Ln - DB: SQL - OS: Windows 2003
adjust first free number (tcmcs047)

We have a custummade table with transport-orderlines which constantly will be used by about 20 people.

What I want to achieve is this :

When I change a customer in one of the orderlines, the script checks for an orderline in the same serie with the new customer. If there is one, use that ordernumber with a new line. (this works already).

When there is no order with the same customer in the serie the first free number in tcmcs047 has to be upnumbered with one (+1). The problem is that I have a multi-occurence form where several customers can be used
The first free number must be upnumbered inmediatly while several orderlines can be changed (by 20 people at the same time). How can I achieve that ?
Reply With Quote