Help

[jothis]

HI FRIENDS

HERE IAM IN A PROBLEM WITH MY PROGRAM

IN MY PROGRAM I HAVE 4 FIELDS IN MY DATABASE (name,folder,bookcase,seq)

MY PROGRAM IS WHEN I INSERT A NAME I WANT TO CHANGE THE SEQUENCE =CURRENT SEQUENCE+1 WHEN IT ARRIVE ON 9999 I WANT TO CHANGE THE BOOK CASE=CURRENT BOOKCASE+1 AND THE SEQUENCE IS ‘1’ WHEN THE BOOKCASE ARRIVE ON 9999 I WANT TO CHANGE FOLDER=CURRENT FOLDER +1 AND BOOKCASE=1 SEQUENCE=1

EG:

NAME FOLDER BOOKCASE SEQUENCE

A 1 1 1
B 1 1 2
C 1 1 3

---- ------ ---- ------
D 1 1 9999
E 1 2 1
F 1 2 2
G 1 2 3

WHEN THE BOOK CASE ARRIVE 9999
----- ------- ------- -----
H 1 9999 9999

I 2 1 1

Please Help me For Doing This
i attached my program
jothis

 

[Monsterman22]

It should be pretty easy. Hope attached .sbp will help you.

 

[jothis]

Thankyou

Thankyou Monsterman22 For Giving This Logic

jothis