I am doing a holiday request db in Notes client…because of the weird system we have at work i had to work out how many firdays somebody has booked off… this was no problem all i did was create a view that only showed docs that had a friday in one of the dates assigned as the holiday for that doc…then the dblookup would add all documents up that were against the person name(when they were adding a new holiday request) that had a friday on em… THe problem is the DBlookup will not add update values. it reports the wrong data against what the view actually says… it will only update if i do a F9 on the view then create the new doc… i have tried nocahce and recache but the data dblookup pulls back is out of date!!!
my code is this
@If(name=“”;@True;@DbLookup(“”:“NoCache”;“TCMP”:“holidayr.nsf”;“all3”;name;5));
The 5 column is just the muber 1 which i do a @sum of to get the total amount of documents in the view… The filtering is done from the view… But it wont reflect the changes… I add one doc the view reflects that but the @dblookup doesnt… only if i look at the view manually or hit F( will it reflect the changes!!! and i do have the view set to Automatic and discard after every use…
Thanks in advance
Antony
PS IS this a known bug or anything???