I wanted to join all my databases into one file.

Is there a way to do it instead of importing and have to create all the layouts and relations all over?

I don't know of an automatic way to do this, but I moved a small database into a much larger one last week, and this was the order I imported (or copy/pasted) in to minimize the amount of broken links and extra work:

tables/fields (can import these from Manage Database if you have FM Advanced)

value lists (best place to do this depends on what kind of lists you have--if you have value lists based on related fields, do this last)

scripts (copy/paste)

layouts (copy/paste elements into new layouts with same name--will have to fix broken links to layouts in scripts, but buttons, etc. pointing to scripts will break if you do this before scripts)

relationships (in relationships graph--repoint existing relationships from external file to new internal tables)

data (import, use matching names)

As I hinted above, certain types of databases might benefit from a slightly different order. It's inevitable that some things will break, it's just a matter of minimizing it, and, of course, knowing where the breakages will be so you can fix them.

HTH

i see thx,

i thought that could be a automatic way of doing it