Get and save a related record.

[-bc-]

I'm working in filemaker pro 11 advanced.  I have a problem I can't figure out.  Here is the situation:

 

I have a table called Program, a table called Staff and a Join Table called PgmStaff.  I have a Layout called Program using records from the table Program.  On that layout I have a portal to the PgmStaff join table where I link up a program to the staff that work at that program.  So far, nothing special.  What I want to do is have a button on the lines of the portal and when I select that button it launches a Pop-Up window (using records from Staff) and displaying in the record the button was on.  I can create the pop-up window but I can't get it do display the related record.  Is there a way to aquire the current record in a variable than pass that to the pop-up when I switch to it?

 

I was hoping to use GTRR but by the time the Pop-Up is created and moved into position the "related record" information seems to be lost.

 

I figure I'm missing something but I can't figure out what it is. 

 

Any thoughts anyone?

 

 

[Nuos]

Yup.

 

Have you worked with global fields to filter a found set?  I have used that in these situations to solve this problem.  

 

1) create a global field in your program table called g_Staff and set it as a text file and as global (under storage tab).

 

2) in your database relationship graph, create a new instance of table "staff" called "staffLOOKUP" and connect program::g_Staff to staffLOOKUP::Name.

 

3) in popup reference fields from staffLOOKUP but make sure the layout is assigned to program table.  This is very important.

 

4) Create script that sets field g_Staff to contents of pgmstaff::name and then open popup display.

 

5) create button in portal that runs script when pushed 

 

WhaLa!

 

Hope that helps

Marcus

[Lee Smith]

I moved your topic from "FileMaker Pro 11" to "Relationships”, because the General Topics are reserved for questions on the tools, functions etc that were new with the release of that FileMaker version.

[comment]

I was hoping to use GTRR but by the time the Pop-Up is created and moved into position the "related record" information seems to be lost.

 

Try using (only) GTRR with the option 'Show in new window' selected.

[-bc-]

Hi Lee,  Relationships is a great place.  My friends say I'm really good in relationships

 

Nuos: Globals are a briliant and, as a mathamatition would term, "Elegant" solution.  Thank you.

 

Consultant: I have not tried that and I will try it out but I'm not sure it provides me the option to control the window as I'd like (size, position, locking it, etc.) but maybe it would.

 

Thank you all.  Its so nice to have people willing to share their ideas!!

[comment]

 I'm not sure it provides me the option to control the window as I'd like

 

The new window options are identical for both New Window{] and Go to Related Record [New Window} script steps. You do not need to modify your schema in order to do this.

 

 

 

mathamatition

 

??

[-bc-]

Consultant:  Works great, I created a script using GTRR as the first function in the script.  I used some custom functions to determine height width and top and set left to a big negative value -5000.  I then turn off status bar, disable user abort, Then move the window to the center of the screen.  It works great!!!  Thanks for the tip.

 

Bruce

[comment]

Couldn't you place the window in the center right from the start?