Jump to content
Salesforce and other SMB Solutions are coming soon. ×

importing data from another database

Lee Strauss

Recommended Posts

hello everybody..


i am trying to figure out how to import data onto an order from from another database but not have the database that was imported from be changed. I already have the relationship set up, and it works fine, but whenever you change something on the new order form it will change on the database that the data was imported from. so, in other words, on the fly i want to be able to grab the info (differnet templates of information), from database 2 and make a copy of it and past it into database 1 but still be able to edit it without it changing on database 2.


any help?

Link to comment
Share on other sites

  • 7 months later...

I have the same question... trying to put together simple 'customers' and 'invoices' databases. I'm new to FM - using version 7.0.


PS I'm learning quickly; this forum has helped enourmously; thanks! :-D

Link to comment
Share on other sites

When you say from "another database", you mean another FM 7 one, correct. I think you set up your layout to have the forms from the exporting database on it. (maybe in a portal, maybe just on the layout). When you change data in these fields, you are actually working on the "exporting" database.


If you have fields set up as "Lookups" instead then you will import the data, but if you change the data, it won't change on the exporting database.



Link to comment
Share on other sites


This topic is now archived and is closed to further replies.

  • Create New...

Important Information

Terms of Use