1 Reply Latest reply on Feb 3, 2014 8:43 AM by philmodjunk

    TABLES

    MarkEmerson

      Title

      TABLES & FILES

      Post

           I have a moved a large data base which was relational from Lotus to Filemaker Pro 12.0V5 via an Excel spread sheet onto Mac OSX.  The original was in fact several data bases that were originally relational but are no longer due to the transfer. I am happy with the day to day use of the programme but having problems trying to establish any relationships.

           1. I have changed the name of the primary DB and also altered the names and position of some of the fields, but in "manage,database " it continues to use the old name followed by "converted" but has all the fields listed.

           2. The  DB with its new name is also displayed but without any fields listed?

           3. In the User manual it talks about Files and Tables and being able to have more than one table within a File. How is this achieved, as I understand it one DB is a table

           So I have a number of perfectly functions DB's but unable to link them, should I go back to the beginning and do things differently [I would rather not as considerable updating of records has also taken place] or can I progress from where I am?

           Thanks in anticipation

        • 1. Re: TABLES & FILES
          philmodjunk

               1) The name you see is not name of the file. When the file was first created from the Excel file, the table was given the same name as your file, but subsequent file name changes will not rename the table. You'd need to switch over to manage | Database | tables to rename the table. And your original layout for that table is also given the same name as this table. It can be renamed in Manage | Layouts or Layout Setup...

               2) And where do you see that? Any layout can be modified to include the fields you need it to have. You can enter layout mode and use either the field tool of the field picker (new tool in FileMaker 13) to add fields to the layout. Or in table view, you can click the modify button and add fields to the view without adding them to the layout if you wish.

               3) One DB is NOT a table. Open manage | Database  and you'll find the tools for adding more tables to your file on the tables tab and more Tutorial: What are Table Occurrences? (not the same thing) on the relationships tab.

               Final paragraph question:

               It sounds like you put each table into a different file. From Excel files, this is easy to do by doing a drag and drop of the excel files onto the FileMaker application or by using Open from the File menu, but this is not ideal--especially for people new to FileMaker. It would be better to select one of your converted files and use Import Records with the "new" option selected for the target table to import the other file's data directly into new tables in the same file. Then you can go to Manage | Database | Relationships and define the needed relationships to make this a relational database. (This can be done with one file in each table, but that starts you out, as a new developer, with a more complex approach for getting the same set of tables to work as a relational system.)