[pilot-db-list] Linked and Calculated fields problems

[Peter W. <pet...@jp...>]

Hi,

Great product -- I find it becoming one of my most used Palm apps.

I do have a problem, though:  I'd like to link to another database
that has:

    Action (String)     Points (Integer)
    ------              ------
	Go shopping         5

I'm using the same basic fields in my second database, the first as a
"Link" field, and the second as a "Linked" field.  So far so good.

However, the problem comes when I setup in the second database a third
"Calculated" field that adds all the "Points" entries up.  Here's what
the second database looks like:

    Action (Link)     Points (Linked)   Total (Calculated)
    ------            ------			-------
	Go shopping       5                 (sort 0 1)(+ %1 (ffr 1 -1 0))

However, the field editor won't let me add in the calculation;
apparently it doesn't recognize the linked-in field as an integer and
automatically disallows the calculation.  Is there any workaround for
this, or any plans to change this in a future version?

Thanks in advance,

-- 
Peter

----------------- SITUATION: *Stupid* User Questions -----------------
TECHNICAL THUG:  Answers question in hex, binary, postfix, and/or
  French until user gives up and goes away.
  -- Stephan Zielinski, "KNOW YOUR UNIX SYSTEM ADMINISTRATOR"