Newbies Dozer Posted April 3, 2004 Newbies Share Posted April 3, 2004 Hello, I have 2 different databases. One that I use for official orders and the other for quotations. I was able to create a script to import the content of a quote to an actual order using serial numbers but when it comes to portal informations, I only get the first line of the quote portal into my order. How do I get my order to import the info of the portals other lines? Help would be greatly appreciated. Thanks FileMaker Version: 6 Platform: Windows XP Link to comment Share on other sites More sharing options...
Ender Posted April 4, 2004 Share Posted April 4, 2004 Welcome Dozer, It's not very clear what your files are and what the portals relate to. Post more info. Link to comment Share on other sites More sharing options...
Newbies Dozer Posted April 8, 2004 Author Newbies Share Posted April 8, 2004 Hi, through hours of testing I finally found a way to get it done. I have two different databases (a and : wich have theire own related records. I wanted to be able to copy specific data from portal in database "a" to portal in database "b". What I ended up doing is having the same related records file for both of the databases and through a "perform search" and a loop for found records command I was able to to set the field from one relationship to the other. It's a little hard to explain but thanks for reading me. My only problem now is that I have to use the clipboard to initiate the search so every time I use the script, I loose the info in my clipboard. Dozer Link to comment Share on other sites More sharing options...
-Queue- Posted April 8, 2004 Share Posted April 8, 2004 Try pasting into a global container field before running the rest of the steps. Then copy the contents when finished. You won't lose the clipboard info. Or don't use copy/paste at all, and instead set related global fields with the data to be transferred. Link to comment Share on other sites More sharing options...
Newbies Dozer Posted July 30, 2004 Author Newbies Share Posted July 30, 2004 Cool! I replaced my copy command with a global field entry and it Worked. Thanks! Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 7182 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now