how do you get file name only
I have a data base that documents photographs by various photographers.
I have a container field for storing an image of their photographs called 'photo image'.
What I need is a field that will show me the file name of the imported image.
All I can manage is -
GetAsText ( photo image )
But this gives me more than just the file name all of which I do not need.
Is there a way to get just the file name only?
Thanks for any help.