Changing a link in the relation graph

[LindaG]

Oh. I think I've been misunderstanding 7. And i want to change a link. Invoices is connected to Customers on CustID. But I want to change it and link invoices directly with Contacts, CustID. They are assigned a unique CustID when they order (easier for customers to refer to). Contacts also has unique ContactID - long computer calc one that isn't displayed (customers and prospects are now together).

I want to ditch the Customer table. It is was stupid and redundant. But I have many calculations and scripts which use this existing Customer table (CustID to CustID). If I unlink invoices and immediately link to Contacts before exiting the diagram, will FM know to correct the calcs and scripts? Or do I need to do that manually. I fear your answer but I'll live. At least I can use DDR to find what needs to be changed. But I hope I won't have to.

Thank you.

Linda

[The Shadow]

You'll need to redo all calculations that reference the Customer table (of course), but calculations that just pass thru it relationally will be fine as long as there is a new path to get to the tables they use.

[LindaG]

Hi there Shadow!

Oh, absolutely wonderful news! I was hoping FM7 was smart enough to wait until I finished reconnecting and, in truth I could have tested it on a clone copy. But there are so many places to check it, one calc might appear fine but another one break somewhere or one line in a script might break. I was afraid to even trust my own testing on it.

I'm a happy camper now though! Thank you!

Linda