Help with a script that will run between two database

[Dani Rubenstein]

HI

i want to have a script that will open database #2 to layout "a" and when the user complete the input data.

The database #2 will close and return to date base #1.

The problem is the user enters database #2 layout name "a" straight ( to the same layout) when he finishes with the layout he should stay on database #2 and not run to database #1.

can some one help please ?

Thank you

Dani

[LaRetta]

Hi Dani,

All work should be handled in the same file - no need to open and close other files at all. :^)

If you mean working in single file but switching to layouts which are based upon two different files or tables then that is different. When you say 'database' do you mean file or table?

[Dani Rubenstein]

Hi i mean file

[LaRetta]

Again, there is never a need to move between files in this way. By adding a file reference from the other file and creating layouts in ONE file, all work can happen there. This will greatly simplify your scripting.

It would also help if you use real names instead of #1 and #2 so we understand the context of the problem.

If a single script can have dual purpose - sometimes exit on a new layout and sometimes return to the prior layout then you can either ask the User (custom dialog) which they want, or you can use script parameter and depending upon certain conditions when they click the button, script can proceed depending upon which button they select. Or you can have the script exit once it is on the new layout if a User clicks another button (which would halt the script).

Understanding the User process here would help. I have no vision of what the User is doing or experiencing to provide more in-depth response. :^)

[Dani Rubenstein]

I have a file name company that has company name & contacts people in the company.

second file is sells.

when the user is in sells and he want to add a new company or contacts the script will open company & contacts file.

[Dani Rubenstein]

The problem I have is the i can't copy the layout to sells file because all the script i have in company.

That is way i want to find a way that filemaker can get how the file was open.

[LaRetta]

Hi Dani,

No prob with two files - I mention it because it makes things easier. Going back to your opening statement of "i want to have a script that will open database #2 to layout "a" and when the user complete the input data. The database #2 will close and return to date base #1."

I am still unclear - my fault. So a User is in Sales. Why? Create a new sale? And THEN they realize there is not a Contact record yet and so you want them to create the new contact record and then return to the sales record? How do you handle navigation normally? Do you have buttons to each layout (or section) as buttons across the top? Or do you use custom menu?

Do you have the New Contact script in your Sales file or your Contacts file? You can create a script in Sales which calls the sub-script New Contact in Contacts and if you end your script with ANYTHING, you will be returned to this Sales file for the script to finish. It can be simple Enter Browse Mode.

I prefer than Users find the Contact and then use button Create Sale on their layout.

You can also just open new window, let User enter data and close it again. But having User select (or create) Contact first is the best way to handle it.

Edited July 7, 2012 by LaRetta