Many to Many relationships

[giles]

Hi Folks,

I've been using a series of "single to many relationships" to produce a way of navigating around a large database. It takes the form of a single record having any number of "children" (which you can navigate to by clicking on). It's been really successful but I now need to reverse engineer this to a point where a record can have A NUMBER (not just a single) number of "parents"

The coolest way of doing this would be with some kind of many to many relationship .... but I'm really not sure if this is possible?

Can anybody help?

Best

Giles

[cjaeger]

why not? just do it!

The "relationally correct" way is to create a cross-reference table.

The FileMaker way is to use multi-keys (eg. return-separated text lists as key.

You just need a reverse relationship from child to parent.

[Ugo DI LUCA]

According to your exact needs, may be the ValueListItems( ) function would suffice here.

File A

Record A-1

---------------> File B

----------------- Record B-1

----------------- Record B-2

----------------- Record B-5

File A

Record A-2

---------------> File B

----------------- Record B-1

----------------- Record B-3

----------------- Record B-4

Where B-1 is related to either A-1 and A-2.

[giles]

thanks for your input folks, your comments pushed me in the right direction ... it works beautifully ... BIG THANKS

Giles