I have two databases. Is there a way to import some of the fields from the old one into the other without creating them all in the new one?
With FileMaker Advanced, you can copy and paste the field definitions from a table in one file to a table in the other.
With regular FileMaker, you can use Import Records with the "new table" option to import the entire table. You can then delete the fields you don't want, leaving the rest. You can link this table in a one to one relationship with an existing table if you wanted to add those fields to an existing table in your target file.
Could you detail the steps for this? I have FMPro 13. When I choose Import Records my choices are File... Folder... XML or OBDC Data Source.
Choose file. Then select the file from which you want to import this table. Then select the table you want to import from that file.
In a later dialog, you'll select New table as the target table.
Ok, thank you. I have done this (I think) but now when I want to insert a field from the imported table it is an 'unrelated table'. How do I change this to a 'related' table?
Go to Manage | Database | Relationships and link the Tutorial: What are Table Occurrences? for the new table to your other table occurrences in a relationship.
Isnt there a way to just combine the two sets of fields together? I am used to working in FMPro6; I liked most of the fields I was using, Idon't use more than one table; I am a very basic user.
Yes, buy FileMaker Advanced and copy/paste the fields. That's not an attempt at either sarcasm or humor here, it's just a fact of how FileMaker works. I recommend Advanced to all people who want to create anything more than a very, very basic database. The added tools not only save time, such as here, but also help new users better understand how FileMaker works. (Stepping through a script in the debugger and watching the value of fields and variables change with each step can be a real "eye opener".)
But if you don't choose to spend those extra $$ (which is quite understandable) then no, there is no simple way to just add those fields to your table. You can, however set up a simple one to one relationship between the two tables, enable "allow creation of records via this relationship" and use fields from both tables on your layout just as though they were all from the same table.
Retrieving data ...