How do I actually seperate the data? I want to be able to add forms and reports without losing data or having to import/export.

In your interface file, define a file reference to your data file. That's it, you're done. Now you can add table occurrences to your relationships graph in the interface file that are based on tables in the data file.

In your interface file, define a file reference to your data file. That's it, you're done. Now you can add table occurrences to your relationships graph in the interface file that are based on tables in the data file.

I need to know how to make an interface file and a data file. I currently have the CrimeBase.fm7 but do not know what to do to make a data file as well. I must be missing something....

Thanks

You might search the archives. I posted some detailed instructions on separating a file some time ago.

Essentially you make a clone of your current file, use that as the interface file, and use your existing file as the data file. You then have to change the references of the TOs in your clone's graph to point to the data file. There are some tricks to do this efficiently -- as Ender said, take a look at the info that's here already.

Gotcha! I think I understand now. I will try it out and see what I get. Thanks