cterrell16 Posted February 10, 2011 Share Posted February 10, 2011 How can you run a script to copy the contents of one field, then open another database, perform a find where it would paste the copied contents to one field. I'm trying to use Copy [select; work order:::Order#] Open file [invoicing] Perform find ? Paste [here's where I have the problem] Link to comment Share on other sites More sharing options...
bcooney Posted February 10, 2011 Share Posted February 10, 2011 You don't. You relate the files by OrderID and use Go To Related Record. Link to comment Share on other sites More sharing options...
comment Posted February 10, 2011 Share Posted February 10, 2011 It would also be better to have the tables in the same file, I think. Link to comment Share on other sites More sharing options...
cterrell16 Posted February 11, 2011 Author Share Posted February 11, 2011 I tried to use the relate function but I'm trying to relate from a portal that is linked to two different databases. Is there not a way to do what I want with copy and paste. I've got it copying the numbers but I can not get it to find, paste into the spot and perform the find. Link to comment Share on other sites More sharing options...
bruceR Posted February 11, 2011 Share Posted February 11, 2011 Copy and paste should be avoided in scripting. You will be much better off in the long run learning about relationships and proper scripting. There is no "relate function". There can be a relation in one file that points to data in another file. Any chance you can post your files or clones of your files? Link to comment Share on other sites More sharing options...
cterrell16 Posted February 11, 2011 Author Share Posted February 11, 2011 I would but my server has the items locked where I can't copy them. There has to be a simple way. Link to comment Share on other sites More sharing options...
bruceR Posted February 11, 2011 Share Posted February 11, 2011 There is; it was provided in the first reply. You can also write a script in the second file that gets called by a script in the first file. This is FileMaker Server? What version of server are you running? You should be able to copy from the backups folder. Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 4794 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