Refresh Lookup value in FM 12 adv

[ron G]

Hi,

I have a membership application which has a MembershipCandidate table.

 

Each 'candidate' is coached by a Member.  Part of the candidate record has the name of the coach along with the coach's phone number.

 

In the table I have a CoachPhone field that is a lookup of the indicated coach's phone.  This works great.

 

The problem:

When the coach's phone changes, the change DOES NOT get reflected in the Candidate report which shows the Coach's phone.

 

I know lookup do not 'refresh automatically' so I tried changing records.  No help. 

What works is 'reselecting' the coach's name from the dropdown from which the name is selected.

 

Question: "Is there a script step or routine I could put in my startup script that would simulate the 're-selection' of the Coach's name and thereby 'refresh' the phone number on the Coach's phone on the candidate's page AND on the Candidate Report?

 

Thanks for thinking about this.

 

 

 

[ron G]

Got it. 

I needed to use the RELOOKUP COMMAND.  I developed a 3 line script that serves to both batch refresh on startup and is called by the ON SAVE script trigger.  Kewl feature...

[Lee Smith]

Automatic message

This topic has been moved from "Advanced & Developer Features" to "Managing Scripts".

 

The topic you posted to is RESERVED for discussion of the TOOLS in the Advanced edition of FileMaker, and not for asking HOW-TO questions. I moved your topic here because you are going to need a script step to relookup.

[ron G]

thank you

[Vaughan]

Why use lookups at all, an not a related field instead? The only reason to use lookups is to save historical information (so that the database remembers what the coaches name and phone number were 4 years ago) or if the info needs to be stored.

[ron G]

"WHy use lookups at all?"

 

The coach and the candidate belong to the same table.  I tried refrencing the coach's phone but when it changed it was not updated in the Candidate's 'area'. 

 

Perhaps I should establish a 'self join' between Member and Member 2...   

 

RIght now it just seems simpler to do a relookup...  Ron