Jump to content
Sign in to follow this  
JariV

Duplicating relationships

Recommended Posts

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

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

×

Important Information

By using this site, you agree to our Terms of Use.