Re: Saving Folder Structure's for FMP
Re: Saving Folder Structure's for FMP
- Subject: Re: Saving Folder Structure's for FMP
- From: Malcolm Fitzgerald <email@hidden>
- Date: Sat, 24 Aug 2002 11:51:46 +1000
I have a question for the group about scripting FileMaker Pro:
My question is about how to store the folder structure of the files. I
can always just store the absolute path for each file in a text field,
but I was wondering if anyone had any better ideas.
One problem with just storing the absolute path with each file is
when searching, I will want to have the users be able to "see" the
folder structure. I'm guessing I'll have to accomplish this with AS
and parse the paths back to a heirarchy, but I'm not really looking
forward to that.
Whinging about the thought of AppleScripting to this list is a bit rich!
This solution doesn't touch AppleScript, it only uses FMP so the
database can even be run from that darn PC. I'd contemplated
suggesting AppleScipt solutions to drag out your misery but its a
sunny day here and I though better of it.
If you import the full path into FMP as a string you can then use
calculation fields to split the path into folder parts.
You'd create, for example, a calculation field which stripped the
file name off the full path - that's the file's container. You create
another which strips the last folder name off the file container
field you've just made (and which builds the folder hierarchy back
one step).
Build self-join relationships to these calculation fields. With a bit
of imagination you should be able to arrange two portals on a single
layout that will display the contents of the current folder and the
other folders stored at the same level in the hierarchy.
You don't need to build the hierarchy back any further than the file
container and one level up. If you want people to be able to move
back more than one step at a time you simply need to generate a value
list from one of the calculation field (which ever best suits your
purpose) and use it in a pop-up list on global field to generate
transient relationships.
Now any questions you might have are FMP questions. There's something
to look forward to.
--
--
Malcolm Fitzgerald email@hidden
Database Manager
http://www.asauthors.org
The Australian Society of Authors ph: 02 93180877 fax: 02 93180530
_______________________________________________
applescript-users mailing list | email@hidden
Help/Unsubscribe/Archives:
http://www.lists.apple.com/mailman/listinfo/applescript-users
Do not post admin requests to the list. They will be ignored.