@DbLookup - File Does Not Exist

HCL Domino Domino Forum
1

I have the following @DbLookup statement and I am getting an error “Field: ProdChemLookup: File does not exist” when I am attempting to open the form.

The field ProdChemLookup is on the current form in the current database. It is a text field with the following @Dblookup statement.

@DbLookup(“Notes”:“”;“8527412:0066103E”;“vv_lookup”;ProdGroupChem;1)

It is looking up to a different database and I put the replica ID in. I have also tried putting the specific server & database name, but it makes no difference.

My key is ProdGroupChem which is on my existing form in my current database. This is a computed field which gets populated once data is entered into another field.

vv_lookup is the view in the database I am doing the @DbLookup to to and 1 is the first (and only) column in the view. The column is sorted by ascending.

I would appreciate any help.

2

Subject: @DbLookup - File Does Not Exist

your replica ID is missing a character. Should be 8:8 and yours is 7:8.

3

Subject: @DbLookup - File Does Not Exist

I think you might have a classic problem here.Is ProdGroupChem populated at the time you are opening the form?. You said it gets populated after something is entered in another field…

I would guess you need something like this.

val1:=@DbLookup(“Notes”:“”;“8527412:0066103E”;“vv_lookup”;ProdGroupChem;1);

@if(prodgroupchem=“”; “”; val1)

But I think your next problem will be a refresh issue once the field is populated.