I have just managed to get the system working under default values as well as a seperate database called marine.

However when I Add a reord I always get a field called location changed to "admin" I can go into the record afterwards and change it no problem The following is my
$db_def String

%db_def = (
ID => [0, 'numer', 12, 8, 1, '', ''],
Date_of_Incident => [1, 'alpha', 12, 8, 1, '', ''],
Fire_Brigade => [2, 'alpha', 40, 255, 1, '', ''],
Brigade_Involved => [3, 'alpha', 40, 255, 1, '', ''],
Vessle_Name => [5, 'alpha', 12, 15, 1, '', ''],
Flag => [6, 'alpha', 12, 255, 1, '', ''],
Type_of_Vessle => [7, 'alpha', 40, 500, 1, '', ''],
Tonnage => [8, 'alpha', 12, 12, 1, '', ''],
Cargo_Carried => [9, 'alpha', 12, 12, 1, '', ''],
Location => [10, 'alpha', 12, 15, 1, '', ''],
Details => [11, 'alpha', 50, 500, 1, '', ''],
);

Hope someone can help

The only thing I can think of is that maybe your $auth_user_field variable is set incorrectly. Since the "Location" field is number 10 in your configuration, my guess would be that you have $auth_user_field = 10.

It could also be caused by your not having a field number 4. I would first renumber the fields, eliminating any gaps in the sequence, and then check the $auth_user_field.

Hope this helps.



------------------
JPD

Many thanks the error of my code has been changed in the form of putting a -1 in the $auth_user_field