AnsweredAssumed Answered

Combining databases....?

Question asked by unitedbiologicsmattg on Dec 14, 2011
Latest reply on Dec 16, 2011 by philmodjunk


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.