Re: [pilot-db-list] Fatal Error with one particular PDB

[Jonathan F. <jo...@gm...>]

On 6/2/05, Yedidyah Bar-David <di...@ta...> wrote:
> On Thu, Jun 02, 2005 at 05:34:16PM +0100, Jonathan Fitt wrote:
> > Thanks. Clearing up that malformed view sorted it.
> >
> > I have a more complicated question.
> > I have a databse which contains archery rounds (the one I sent) and
> > the number of dozen arrows each entails. I also have a database of my
> > scores. One of the fields in the score database is a link to the
> > rounds database so that I can select a round name. In my score
> > database I have the number of hits. I want to take this and the number
> > of dozen field from the corresponding record in the round database and
> > work out my hit percentage as a calculated field. Is this possible?
> > Basically in my record I want to read a field from another record
> > linked to by a field in the record.
>=20
> It's not possible, as far as I understand. I do not know how much work
> it would take to make it possible - it might not be that much work.

I've worked out how I would do it. I can make a linked field which
points to the dozens field in the record the original link field
points to. I can them have my percentage field take the value from the
linked field, and the number of hits, and display a percentage.

I have a new question though:
Is it possible to get back into the calculated field definition after
setting it? The only way I can get back in is by changing the field
type to something else, and then back to calculated. However this
deletes its contents.

Also, what do global scripts do, and what is an example use for them?

Thanks,

Jonathan