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:
The data is related by a common project number.
I would prefer this arrangement:
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.