Re: FileMaker Pro Advanced - design question...

#1

piscesboy <oraclmaster (AT) gmail (DOT) com> wrote:

Quote:

I've got a database that stores folder names and files in those
folders.

So, I've got a table called Folder and a table called File. The Folder
table is linked to the File table through a folder ID field in the
File table, because folders contain many files.

But Folders also contain other folders, so I need to create a
recursive relationship between two instances of the Folder table, but
the relationship graph in FMP doesn't allow me to draw a relationship
between two instances of the same table. I can't make a relationship
between two instances of the Folder table.

Help?

First point: there is a comp.databases.filemaker newsgroup specifically
for FileMaker Pro, where a lot of knowledgeable people hang out. You
would probably get more answers there. I've included it in this post but
haven't limited followups.

I think the easiest way to have a self-referencing table is to create
another "join" table, where every record contains two fields: parent
folder ID and child folder ID. You then have two relationships linking
the join table to the Folder table.
--
David Empson
dempson (AT) actrix (DOT) gen.nz

#2

On Sep 24, 9:12*pm, demp... (AT) actrix (DOT) gen.nz (David Empson) wrote:

Quote:

piscesboy <oraclmas... (AT) gmail (DOT) com> wrote:

But Folders also contain other folders, so I need to create a
recursive relationship between two instances of the Folder table, but
the relationship graph in FMP doesn't allow me to draw a relationship
between two instances of the same table. I can't make a relationship
between two instances of the Folder table.

Help?

PiscesBoy,

You don't create relationships between tables. You create
relationships between "table occurrences". And while you can't create
a relationship between the same TO, you can create multiple TOs from
the same base table and create relationships between them.

G

#3

On Sep 25, 2:07*am, Grip <gripdevelo... (AT) gmail (DOT) com> wrote:

Quote:

On Sep 24, 9:12*pm, demp... (AT) actrix (DOT) gen.nz (David Empson) wrote:> piscesboy <oraclmas... (AT) gmail (DOT) com> wrote:

But Folders also contain other folders, so I need to create a
recursive relationship between two instances of the Folder table, but
the relationship graph in FMP doesn't allow me to draw a relationship
between two instances of the same table. I can't make a relationship
between two instances of the Folder table.

Help?

PiscesBoy,
You don't create relationships between tables. *You create
relationships between "table occurrences".

That's what I've been doing all along. I've got multiple file TO's
that I use for different layout views.

*And while you can't create

Quote:

a relationship between the same TO, you can create multiple TOs from
the same base table and create relationships between them.

G

Nevermind. It seems the act of posting something to a message board
magically has the effect of making the answer obvious five minutes
after clicking the "send" button. I simply created another TO in the
graph and added a "parent ID" field to the folder.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Re: FileMaker Pro Advanced - design question...

comp.databases.filemaker comp.databases.filemaker

Re: FileMaker Pro Advanced - design question... - 09-24-2010 , 10:12 PM

Re: FileMaker Pro Advanced - design question... - 09-25-2010 , 01:07 AM

Re: FileMaker Pro Advanced - design question... - 09-25-2010 , 04:21 AM