3 Replies Latest reply on Dec 16, 2011 10:43 AM by philmodjunk

    Combining databases....?



      Combining databases....?



      I am using FMP11 on Mac OSX 10.6.8; I recently purchased FMP and have no prior experience or training, so I have been doing a lot of trial and error. Currently I am using 2 starter solutions in 2 separate databases; I have the "parts log" using the "inventory" starter solution and then "purchase orders" using the "purchase orders" starter solution. Although, I am trying to make it so that I can look up the parts from the parts log when making PO's; so that the 2 are connected. I know that I can just go in and make the field capture the data from the parts log database, which is how I have it setup right now, although if possible I would like to convert them into 1 file and just be two separate tables. 

      Although, I am not looking for how to make the scripts connect like that currently, all I'm trying to do is get the layout I made into the other database (and the info too if possible; but it's not that big of a deal if it doesn't go). 





      So far I have made a layout, table, and copy and pasted the "purchase orders" layout into the parts log. Although currently it says "field missing" in all of the edit boxes due to the values and line items not being transfered. So I am trying to transfer the line items easily. I only have 6 fully made PO's that would only take 10 minutes to start from scratch with, and I could just individually type in the values such as "K_ID_PO" etc, but my problem is that I don't know how to set up the "indexing" and "calculations" that some of the line items in the template already have setup. 

      So, I am looking to pretty much "combine" the two databases via some form of "copy and paste", transferring all the info I have in the "purchase orders" database, into a table in the "parts log" database (which would get renamed obviously, because it's no longer just the parts logTongue out)


      edit : I tried "importing record" into a new table/layout (which FMP deemed as "purchase orders 2") and that DID get them into the "parts log" file, and it looks perfect in table view. But, when I switch to list view it's in this funky layout with these weirds tan pyramid boxes and out-of-focus bar graphs in the place of all the "hitle" stuff (IDK what that stuff is supposed to do anyway).

      I tried going to "edit layout" and just selectall-ing and then deleting, but that takes all the fields and values with it (which is kind of confusing, as when making the layout the first time, if I deleted a box it didn't delete the column off the table view). So then I tried making a new layout, pasting the design from the "Purchase Orders" Data base, and then "linking" the layout using "show records from" but it still says "unrelated table" in all the fields. 

        • 1. Re: Combining databases....?

          You might find the "Filemaker for Novices" Whitepaper useful  http://www.foundationdbs.com/downloads.html

          The company that did the templates for Filemaker also have free templates that have multiple tables
          Useful for examining a more complete solution and looking at the structure.







          David Anders
          The Computer Guy, Seattle

          • 2. Re: Combining databases....?


            I appreciate your response an the "Filemaker for Novices" article will most likely be very useful. 

            Although, I looked at many of the templates you listed, and all of them seem like they would require a lot of modification to get to the point that will work. We are currently using other systems for accounting, payroll, staff, contacts, etc which will not be moved into filemaker any time soon. So for now all that I need to track is Vendors, Purchase Orders, and Parts/inventory. 

            I have both my PO's and inventory setup to my liking after several hours of modification to the templates, and would hope not to need to start from scratch. All I am trying to do is combine the two into 1 database without needing to make a template from scratch. From what I've experienced you can't implement a template into a pre-existings database, only use it to make a new databse. If I could this would be an alternate solution if transferring the modified layouts from one database into the other is not possible. 

            While having 2 separate databases works as a temporary solution, I am looking to have parts automatically added to the inventory list when non-inventory parts are entered into the PO's. While this isn't necessary what I'm looking to do immediately (because I don't yet know how), I am at least trying to set up the foundation for this to be done in the future. 

            So, if there is a way to transfer one layout seemlessly into another database, if you could please describe how to do so, OR direct me to an alternate method if this is too complicated, such as just transferring the layout and just re-assigning all the fields manually (which is looking more and more like an option at this point) I would really appreciate.

            Thanks in advance,

            Matt Grimes

            • 3. Re: Combining databases....?

              The December FileMaker eNews has a "how to merge files" tip you may want to look at. It's not a quick process and you have to be meticulous, but it can be done if you perservere.

              Click Here.