Chapter 2
|
Customizing database solutions 13
1 FileMaker Pro Advanced retains references to scripts, script steps,
and fields if they are valid when you paste. If you copy multiple
scripts, script steps, or fields that reference each other, copy them in
one step to retain the references. If you copy them one at a time, the
references may be lost. Check all references after pasting to ensure
they are valid.
1 To copy and paste scripts, you must have write access to the source
script and privileges to create scripts in the destination file.
1 To copy and paste script steps, you must have write access to the
source and destination scripts.
1 To copy and paste fields, you must have full access privileges to the
source and destination files.
1 When you copy scripts with disabled script steps, the steps remain
disabled when pasted in the new location. For more information, see
“Disabling script steps” on page 58.
1 When you copy scripts or script steps, breakpoints are not copied.
However, when you duplicate scripts or script steps, breakpoints are
retained.
Copying or importing tables into a file
With FileMaker Pro Advanced, you can consolidate tables from a
multi-file solution into one file. There are two methods for
consolidating solutions:
1 Copy table schemas — Open source files to select and copy the
tables you want. Then, paste the table schemas into the destination
file.
1 Import table schemas — Import table schemas directly into the
destination file. You can import just the schemas or import data with
a single schema. (To import the data with a single schema, choose
File
menu
> Import Records > File. For more information, see Help.)
When you copy or import tables:
1 FileMaker Pro Advanced retains references to tables, fields, and
scripts if they are valid when you copy or import. If your tables
reference each other through fields, copy or import the tables in one
step to retain the references. If you copy or import them one at a time,
the references may be lost. Check all references after pasting or
importing to ensure they are valid.
1 Open the Import.log file, normally located in the folder with your
destination database, for details on unresolved references and items
that were renamed due to a naming conflict. If you’ve opened the
destination database remotely or do not have write access to that
folder, check the
My Documents folder (Windows) or Documents
folder (Mac
OS).
1 You must have full access privileges to the source and destination
files.
1 Privileges from the source file are not retained. You must redefine
privilege sets in the destination file.
1 Relationships between table occurrences are not retained.
1 You must convert database files from versions of FileMaker Pro
earlier than 7.0 before importing tables. For more information about
converting databases, see the
FileMaker Pro User’s Guide.
Copying table schema
To copy table schema:
1. Open the database file that contains the table you want to copy.
2. Choose File menu > Define > Database > Tables tab.
3. Select the table you want to copy.
4. Click Copy.
5. Open the database file where you want to paste the table.
6. Choose File menu > Define > Database > Tables tab.
7. Click Paste.
