1 Reply Latest reply on Mar 31, 2010 9:54 AM by philmodjunk

    Merging two templates



      Merging two templates


      Hi all


      I've just started using FileMaker 10 Pro today for work.

      I've managed to find two templates that do what I need to do, but not 1 :(


      I want to record all training events (& have a calendar view) which I've got in one template. But the other template has got the employee records with events and attendance. So the first one really I just need the calendar view.


      I've tried import the records from the calendar template into the second one and then copying the layout. But this doesn't seem to work. Maybe something to do with scripts?? Can I export / import / copy scripts from one file to another?


      Any help would be great.

      Or if anyone has a Learning Management System template, that would be even better :)





        • 1. Re: Merging two templates

          You can import scripts. That's an option you can find in Manage Scripts...

          You can copy and paste all the layout objects from a layout in one file to a layout in another, but you have to be very meticulous about this and get other parts of your database set up correctly first. (The layout needs the right name, it as to refer to the correct table occurrence, you may have value lists that need to be defined first...)

          You often have to paste the same layout objects twice in order to have buttons that work.

          (Paste layouts, Import scripts, delete layout objects, paste them again.)

          Your imported table may have calculation fields that are enclosed in /* comment brackets */ and you have to fix the error that caused this (Such as a missing table occurrence) and then remove the brackets.


          It's usually much simpler just to keep your tables separate and link them via a table occurrence in Manage | Database | relationships. You can use this approach to link tables in separate files just as though they were present in the same file.