loosing the content of a field

[domb]

Hello !

I am trying to open pdfs from a database and I managed to do it thanks to this forum (cf. openurl )

I have at the start of the database a field named "path to folder" where I enter the path to a folder containing the pdfs (e.g. /Users/myuser/pdfs). This field is also defined as "Auto-Enter" with "Value from previous record".

This will allow me to easily use the database on different computers/users, by just changing this path.

For each database entry I have the possibility to add 20 pdfs. I made a field for each named "name of pdf1", "name of pdf2" etc.. where I enter the exact name with extension of each pdf to open.

For each pdf I have also a field "path to pdf1", "path to pdf2" etc..

which is the result of a calculation:

"file://" &path to folder & name of pdf1", "file://" &path to folder & name of pdf2" etc...

Then I use the open url script to open "path to pdf1", "path to pdf2" etc... and it works well.

BUT there is a problem: I am actually loosing the content of the field "path to folder" !

Example:

Under a new database entry I enter the nane of a new pdf in the "name of pdfx" field, but the "path to pdf" field shows: file://name of pdf instead of file://path to folder/name of pdfx

The content of the calculation in path to pdf field is as mentionned before: "file://" &path to folder & name of pdf1".

I really don't understand why, it doesn't take the "path to folder" field into account.

If I go back to the field "path to folder" it is empty. If I quit the database and start again, the database is there again but I still have the same problem.

Can someone help me ?

Thanks

[BobWeaver]

Check that the field definition for the path is correct. Maybe you have a regular text field where it should be global or vice versa.