Hi,

I'm very new to FMP. I have a couple of files:

1. School_project - which contains

school_id, project_id, ... and a BUTTON

I want the user to be able to click on the BUTTON and have it

bring up a layout from another file (pub_quotes)

this file contains project_id, pub_cd, qty, etc..

the common field is the project_id - however the two layouts are in

different database files (school_proj.fp5 and pub_quotes.fp5).

Any help would be greatly appreciated!

Thanks!

Hi,

Create a script in pub_quotes which goes to the layout you want to display.

In School_project create a script that first goes to the related record in pub_quotes based on project_id and then calls the external sript in ppub_quotes which goes the to correct layout.

Then connect that script to your button.

Email me if you don't know which script steps to use.

Gabriela

thanks - I created a script in pub_quotes:

Enter Browse Mode []

Go To Layout ["SchoolPubQuote"]

Show All Records

However, I could use a little help with creating the script for the School_project file - that will go the the related record in pub_quotes based on project_id and then call the external script "openPubQuoteLayout" listed above. I'm new to this syntax.. so any sample code would be very helpful!

Thanks again!