Get Maximum on server !

[Anh_Tran]

Dear All,

I got field number and calculate maximum of it and I take maximum plus 1 ..let's say maxium = 100 and nextmax is 101. if at the same time, my friend open that file and he click the button he get maximum is 100 and nextmax is 101 also. It can not be like that ...he is supposed to se nexmax is 102. Since the file is on server. it should calculate automatic ...am I right? ..but i don't get it right.

Someone has an idea?

Thanks

Anh Phu

[-Queue-]

Have you set the field with Max + 1 and then exited the record? If not, then the Max for that field would be the same for anyone in the file.

[Anh_Tran]

OH I will try tomorrow Queue.

Thanks Queue.

Anh Phu

[Anh_Tran]

Hello Queue ... I try to set Max + 1 and exit the record but it give me the same max for everyone in the file.

Do you have any idea what happen?

Thanks

Anh Phu

[Anh_Tran]

It seems to me that while on the server, i create a new record and assign maximum + 1 to a new record, the second user comes and can not see the new record has been made even I click show All, that is why it can not create a correct maximum +1 ...Am I correct about it? ...someone has an idea about it?

Thanks

Anh Phu

[Anh_Tran]

I found out that on the server if two persons go to same record they can delete it without error message. and about the maximum number is that the first person has to finish to fill in the required field then the second person create new record and get the new maximum correctly. If the first person is filling the required field and second person creates new record, he will get the same maximum.

How can we prevent it?

People can give me advice.

Thanks

Anh Phu

[-Queue-]

This is why I mentioned 'exiting' the record. Your new record doesn't exist completely in the file until you Go to Field[] or Exit Record. Then it becomes 'committed' and other users can view it and calculations with all records will include it. Create your new record and set all 'required' fields, i.e. those that you must enter or you will get an error when leaving the record and those which are vital to other calculations, like your Max field. Then Exit Record, your record is now committed and you can either Go to Next Field or Go to Field[field name] to continue entering your information.

[Anh_Tran]

Hello Queue,

I got your point. It works perfectly.

Thanks

Anh Phu