Duplicating relationships

[JariV]

Hi,

Is it possible to duplicate a relationship table in relationship graph window so, that also the relationships get copied?

If I click the double-cross icon to duplicate a selected relationship table, the resulting copy is only an empty table without realtionships, eg. Table1 (several relationships) gets copied as Table1 2 (but no relationships).

Filemaker Help describes the function of the double-cross button as "Duplicate selected tables (and relationships) and selected notes"

I must be missing something here?

Jari V

[Søren Dyhr]

How do you select the involved tables and relations, I would shift click on each table before the double+ ...the thing is that I can't imagine how you manage to copy the tables without the relations, other than plucking each table individually and issue double+ for each.

--sd

[JariV]

When copying a single table, say Table1, I click on it, its frame becomes highlighted. Then I click the double+ button. The result is a new table named Table1 2, but it is empty (the relationships from Table1 are not copied).

Is this not the correct way to copy a table and its relationships?

Jari V

[Søren Dyhr]

No it isn't, you need to highligt the entire structure, you wish to dupe, either by shift clicking or markee-ing, that is draging the mouse diagonally across objects to make a rectangualar that surrounds table occurrences as well as the strings connecting them.

--sd

[JariV]

Thanks for explaining that.

The reason why I'm trying to copy just a single table with its relationships, instead the whole structure is that I need to have the original table and the copy of it (which would be modified after copying)linked to the same table occurrence, otherwise data based on these two relationships cannot be displayed in the same layout without using portals.

The reason why I want to copy, say TableA (related to TableB) so that the TableACopy is also related to same TableB (not another instance of TableB)is that I have quite a few many-to-many relationships that are almost identical, just one relationship in the many-to-many is different. Copying/renaming an existing related table and then changing that one relationship in the many-to-many would be quite practical, but I guess in this case the copy function cannot be used the way I thought.

Thanks anyway for your help.

Jari V

[Søren Dyhr]

The reason why I want to copy, say TableA (related to TableB) so that the TableACopy is also related to same TableB (not another instance of TableB)

I can't be certain here, but it seems like you're barking up the wrong tree, and overcomplicates your graphing slightly. Take a look at how simple the graph is here:

http://www.fmforums.com/forum/attachment.php?attid/7281/

--sd

[JariV]

I must admit that some of the many-to-many relationhips used here are maybe too complicated, but once they are set up (in this case "manually" instead of copying/modifying an existing one), they are just great for this solution.

Thanks again for your help.

Jari V