Get Filename and FilePath

Iam using this formula to select a file.FIELD fld_filelocation_SRD := @Prompt ([LocalBrowse]; “Select a database to open”; “1”);“”

But this code opens and displays as:

C:/Myfilefolder/orderfolder/orderfilename.doc

What I need is for this to display reverse.

orderfilename.doc (The browse button should be here)

then another column the filepath is automatically added. C:/Myfilefolder/orderfolder/

Can you please inform me how can this be accomplished. Thank you.

Subject: Try:

P1 := @Prompt ([LocalBrowse]; “Select a database to open”; “1”);""Sep := @If(@Contains(P1; “/”; “/”; “\”);

FIELD fld_fileName_SRD := @RightBack(P1; Sep);

FIELD fld_filePath_SRD := @LeftBack(P1; Sep) + Sep;
“”

Subject: Root of any db file.

Bill,

If you’re not the admin, do you know a way to get the entire path to the root of the file (any db file)?

Thx,

Pam Henry.