dbTalk Databases Forums  

hierarchical classification and portal link

comp.databases.filemaker comp.databases.filemaker


Discuss hierarchical classification and portal link in the comp.databases.filemaker forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
manet
 
Posts: n/a

Default hierarchical classification and portal link - 06-09-2007 , 10:57 AM






FMP 8.03

it's about hierachical classification. In a single table with an unique
ID for each element, elements can have different level (1 to 7), and the
ID of the precedent level is in the Father field.

From the master table,I defined 3 links :
- to Father (Father -> ID) : father table
- to Sons (ID -> Father) : son table
- to Brothers (Father -> Father) : brother table

so, I can, from an element in the master layout
- go to father directly
- see Sons in a portal (and go to, via a button in the portal)
- see Brothers in a portal (and go to, via a button in the portal)

works fine

now, what about a refinement : in the Brothers Portal, it would be nice
to have a mark or a special color to see wich one is the present
element.
I know how to get a conditional color, but wich condition ?

I tried identity of ID between master and brother, evaluating from
master or from brother, without result.

Perhaps could I run a script giving an order within the brothers ; it
has to be run at each modification of the classification (once a
year),it's not really a complication, but it isn't elegant.

I can send a trial file to interested people (92 ko)
--
www.D-L-S.org

Reply With Quote
  #2  
Old   
Hans Rijnbout
 
Posts: n/a

Default Re: hierarchical classification and portal link - 06-09-2007 , 01:06 PM






manet <pmanet (AT) invivo (DOT) edu> wrote:

Quote:
now, what about a refinement : in the Brothers Portal, it would be nice
to have a mark or a special color to see wich one is the present
element.
I know how to get a conditional color, but wich condition ?
The condition is that the portal record is the currently active record.
So you need to keep track of the active record, by storing its recordID
in a global 'currentrecordID'. Then the condition reads: recordID =
currentrecordID. This is only possible with fully scripted record
navigation. In every record navigation script you set the value of
currentrecordID to the recordID of the target record.

--
Hans Rijnbout
Utrecht, Netherlands


Reply With Quote
  #3  
Old   
manet
 
Posts: n/a

Default Re: hierarchical classification and portal link - 06-09-2007 , 05:57 PM



Hans Rijnbout <jrijnb (AT) xs4all (DOT) nl> wrote:

Quote:
storing its recordID
in a global 'currentrecordID'. Then the condition reads: recordID =
currentrecordID.
works fine, thanks to you

Quote:
This is only possible with fully scripted record
navigation.
yes, I tried with a calculated global, but don't work.
--
www.D-L-S.org


Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.