AnsweredAssumed Answered

Move table to separate file and maintain relationships and scripts?

Question asked by miketibbit on May 16, 2016
Latest reply on May 16, 2016 by electon

I'm in the process of developing a solution and decided mid-stream that I need one of my tables to be a stand-alone file and no longer be a table in it's existing file. It it possible to move it out and retain relationships and scripts associated with it easily?


For simplicity sake existing FileA has (2) tables:

1) Projects

2) Expenses

The data is related by a common project number.


I would prefer this arrangement:


1) Projects


1) Expenses

Data related by common project number.


FileB will live on a remote server and be accessible by several other Web Direct solutions, whereas FileA will live on my local network and access FileB remotely.