Hello

I am working on a two file solution that has many tables, the first file is cloned for customers every customer gets the same file wich is given a unique name, the second file is different for each customer. All are served by FM server 9.

My problem is because the second file is different for each customer (and has to be to named differently) how can I deal with this without recreating all the relationships.

The second file holds contract details ie. bank acc., National Insurance, Payments etc.

I can explain myself a little better I hope, if I have more than one identical solution on the server, ie one for companyA one for companyB and each one has a second related file which has a different name how can I clone each without making changes to the relationship structure, ideally I would like to have each solution in a different directory but it seems that this is not possible please prove me wrong.

Thank you

Edited November 24, 200817 yr by Guest

Look into File > Manage > External Data Sources… Once you change the file path there, the relationships should adjust themselves.

Thank you Comment, I will test it tonight and let you know if it works.