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

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.

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