Got it; I had misunderstood your idea, which works.
John Weinshel Datagrace Vashon Island, WA (206) 463-1634 Member, FileMaker Business Alliance Certified For FileMaker 10 -----Original Message----- From: FileMaker Pro Discussions [mailto:[email protected]] On Behalf Of Charlie Abrams Sent: Wednesday, November 04, 2009 11:57 AM To: [email protected] Subject: Re: Identifying the Current Record Hi John, Having the portal record's foreign key = the primary key of the current record has always worked for me when it comes to highlighting / conditional formatting. In Richard's case it is the same concept only that it is a self relationship based on category. Therefore pointing the primary key of the portal record to the primary key of the current record works. -Charlie On Nov 4, 2009, at 2:43 PM, John Weinshel wrote: > There's not really any passive way for a child record to know it's > also a > parent. Filemaker is fairly event driven; you'll need some kind of > event to > tell that child the news. > > If you're using Filemaker 10, then that event can be loading a > record, which > would drive a script trigger. The script would set a global to the > value of > the current record's ID. The conditional formatting in the portal > row would > be revealed if the ID of the record in the portal row were the same > as the > global. > > In other words, the formula for the conditional formatting would be: > > Record_ID = Global_ID > > The script triggered by OnRecordLoad would be: > > Set Field["Global_ID"; "Record_ID"] > > OnRecordLoad is a layout trigger; it will be called each time you > 'page > back' to a different record. > > If you are using an earlier version, you'll need to script navigation > between records, and then add the same script step to the nav script. > > > John Weinshel > Datagrace > Vashon Island, WA > (206) 463-1634 > Member, FileMaker Business Alliance > Certified For FileMaker 10 > > > -----Original Message----- > From: FileMaker Pro Discussions [mailto:FMPRO- > [email protected]] On > Behalf Of Charlie Abrams > Sent: Wednesday, November 04, 2009 11:11 AM > To: [email protected] > Subject: Re: Identifying the Current Record > > Highlight the portal record fields in layout mode. Select Format > Menu/ > Conditional. Under the condition, select Formula. In the calculation > dialog, have your "'framistans'" ID = to the parent record key. In > other words, if the parent key for the framisans record is equal to > the parent key of the current record, then do something. > > Charlie > Bonding Solutions, Inc. > > > On Nov 4, 2009, at 1:51 PM, Richard S. Russell wrote: > >> Here's a little problem I'm encountering, and I can't figure out a >> way around it. Probably I'm just overlooking something obvious. >> >> My problem is that every record thinks that IT is the current record >> - or at least it behaves that way - and there seems to be no easy >> way to check to find out if it really IS the current record. >> >> To help make this problem statement easier to understand, I'm going >> to introduce a new term: "This Record". Let me illustrate what I >> mean. Here's a very brief set of records from the "Widget" database: >> >> ID SKU Price x Qty = Cost >> 11 AAA $0.99 x 100 = $99 >> 22 BBB $2.80 x 200 = $560 >> 33 CCC $0.42 x 300 = $126 >> 44 DDD $5.00 x 400 = $2000 >> >> So the AAA record "thinks" that the "This Record" value for Price is >> $0.99, the BBB record "thinks" that the "This Record" value for Qty >> is 200, the CCC record "thinks" that the "This Record" value for >> Cost is $126, and (importantly) the DDD record "thinks" that the >> "This Record" value for ID is 44. >> >> Now suppose you click on CCC to make it the current record. As you >> would expect, it "thinks" that the "This Record" value for ID is 33. >> It also "thinks" (accurately) that the "CURRENT Record" value for ID >> is 33. >> >> But what do AAA, BBB, and DDD "think" is the "CURRENT Record" value >> for ID? Danged if I can figure out how to compute this and >> communicate it to them. >> >> Let me explain just briefly why I'm trying to figure this out. I've >> got a database where the records are subsetted into categories. The >> specifics don't matter. Let's say the database tracks "Widgets" and >> some of the values in the "Category" field are "doohickeys", >> "whatchamacallits", "thingamabobs", and "deelybobbers". I call up a >> record for a Gold-Plated Framistan Type 2, which falls into the >> category "framistans". A link of "Category" to itself enables me to >> display a portal showing ALL the framistans in the file, one of >> which is, of course, the Gold-Plated Framistan Type 2 that we're >> currently looking at. >> >> What I want to do is display a yellow highlight behind the line in >> the "framistans" portal on which the Gold-Plated Framistan Type 2 >> appears. If I then page back to the previous record, for the >> Platinum-Plated Framistan Type 1, I want THAT record to be >> highlighted in the portal. >> >> How to do this? >> >
