I managed to make the connection work. I tried inserting records from 2 computers. It works fine untill 2 computers insert a nextwall one after another.
Here is a small example of what i see in my DB ++++++|+++++++++++++++++|++++++++++ N ° | Session | Number ++++++|+++++++++++++++++ |++++++++++ 1 | DB last record | 269 2 | PC A (nextval ) | 270 3 | PC A (nextval ) | 271 4 | PC A (currval ) | 271 5 | PC A (nextval ) | 272 6 | PC A (nextval ) | 273 7 | PC B (nextval ) | 274 8 | PC A (currval ) | 274 9 | PC B (nextval ) | 275 10 | PC A (nextval ) | 276 Isn't currval connected to its session?? I expected line N° 8 (PC A) to have the Number of the record it inserted a while ago (line N° 273). Thank you. Shavonne Wijesinghe