![]() ![]() When you copy calculation fields, your results may vary depending on whether you also copy the field's calculations reference (Section 9.2.1). Then open the table where you want to create the new fields, and finally click Paste to do the deed. When you've selected the fields you need, click Copy. Use the key (Mac) or the Ctrl key (Windows) to select fields that aren't next to each other in the list. Use the Shift key to select items next to each other in the field list. If you have complex calculations that you want to reuse in another table within the same file, or in a different file, use the Copy and Paste buttons on the Fields tab in Define Database dialog box. If you see an error in the summary window, click the Open Log File button to see what went wrong. Tip: When FileMaker Advanced builds your new tables and fields, it saves a record of its progress in a log file. You see a summary of how many tables and fields were created during the import. When FileMaker Advanced has finished importing the tables and fields, it displays a dialog box similar to the one you see when you import data (Section 17.3.1). ![]() So if there are a few you don't need, delete them when the import's finished. You don't get to specify which fields are imported they all come in. You see a simple list of all tables in the source file you've chosen. Next, you tell FileMaker which specific tables to import in the dialog box shown in Figure 19-10.įigure 19-10. You can even choose the current file, effectively copying an entire table or set of tables within the same file. Click Import, and then locate the file that contains the table you want to copy. Start by choosing File images/U2192.jpg border=0> Define Database and clicking the Table tab. It lets you import tables and fields without the accompanying data, so you can copy the framework and fill in the information later. #How to make a duplicate filemaker pro database how to(You need full access privileges in both the source file and the target file to import or copy and paste elements from file to file.)īack on Section 17.3.2, you learned how to have FileMaker create tables and fields as you import data. FileMaker also provides Copy and Paste buttons in several major dialog boxes so that you can reuse fields, scripts and script steps. Here, a claculation shows users content from the next record in the found set.Īs this section describes, you can import tables and fields without copying data between tables in the same file and between different files. Click the Specify button and you have all the power of the Specify Calculation dialog box at your fingertips. You can type plain text, or create a calculation to display a tooltip. By copying work you've already done, you can spend less time defining fields or recreating complex scripts and more time doing the creative work of designing a database.įigure 19-9. Since a large percentage of a database designer's work is fairly repetitive, FileMaker Advanced provides some tools that let you take shortcuts through the tedious process of creating tables, fields, and scripts. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |