relookup,find,sort not updating when related field

[tdav]

Hi

I don't really know what I'm doing but I've managed to bumble thru and make a little project manager that I'm reasonably happy with except........

I have a database of "Projects" and a separate database for "To Do" stuff

When I click the "To Do" button (in Projects db) its supposed to open ToDo db, relookup related fields in Projects db and find tasks and omit tasks were progress = 100%. In other words uncompleted tasks in proects db = To Do. the trouble is it won't update and show new tasks I have entered or remove tasks I have set as Progress=100%

I realize it is difficult to picture exactly what i'm doing so I've attached the whole mess if anybody has the time. Woops!... its' too big. All my external linked documents and scans seem to have come on board

[danjacoby]

Lookups are kludgy things, and they don't always work. I suggest changing that part of the script.

Check to make sure that any relevant calculations are unstored.