add record in another db and return to first db

[Vanessa]

This seems like such a straight forward thing to want to do, I can't understand why I can't make it happen!

 

The user is entering a job in the job list db. I would like to create a button which the user can select to take them to the client db to enter a new client and associated details and then automatically return to the job list database.

 

All the scripting seems to do relates to the file I am in, not the one I want to go to.

 

Please can you help me?

[andygaunt]

Hi Vanessa,

 

What you would do is create a button in your job list db. this would perform an external script in the clients db.

 

Perform script [external, clients.fp5 "Add new record"]

Exit Script.

 

The external client script would then do

 

New Record Request

Go To Layout [x, refresh]

Go to field [first field]

 

Now, if you want to then go back to the job list after entering, you can either add a pause nto your script so it waits for them to fill in the relevant information (but this means they cant press return as this would continue the script)

 

If this is ok then your script would become

 

New Record Request

Go To Layout [x, refresh]

Go to field [first field]

Pause/Resume

Toggle window [minimize]

Exit script

 

Alternativley, give them a button to press that runs a script that either hides the current window, or runs a script in the job list db.

 

Either or, upto you.

[Vanessa]

Thank you so much for your help so far...BUT...

 

this is so frustrating!!!- I have just spent the best part of the day trying to apply your scripts - but I am obviously doing something wrong - it is just not working...

 

This is what I have done:

 

In Job list db I have created a script called: ADD NEW CLIENT

Perform script [external: "client file.fp5"]

Exit script

 

In Client File I created a script called: ADD NEW RECORD

Go to Layout [refresh window, "client details"]

New Record/Request

Go to Field ["prefix"]

 

I then made a button in the job list database to run the script ADD NEW CLIENT

 

When I click the button I get a new record in the Client file - but I remain in the job list - so I am just stacking up a load of empty client records!!! [luckily I am working with dummy data - so that is not a problem].

What have I done wrong?

[andygaunt]

This issue has now been solved.

 

The problem was the exit script step after the perform external script step.

 

Because the external was not pausing or did not halt the script, it was returning to the job list database and exiting the script.

 

the new records were created in the clients database, but the jobs database was returning to the front, hiding the input for the new client record.

 

So, removed exit script and everything is good again in the world.