Why isn't @dblookup working?

HCL Domino Domino Forum
1

I am trying to design an entry form to where the user types in a serial number for a piece of hardware. When hitting the tab key, the form would automatically produce the hardware description.

Here is the code for the description field:

@If(Serial != “” & Hardware = “”;

    @DbLookup("";"";"SerialNumbers";SerialNumber;2);Hardware)

The view is called SerialNumbers and the column SerialNumber is sorted.

Would anyone have any ideas to why this code does not work?

Thanks

2

Subject: Why isn’t @dblookup working?

Hello,

Just a thought… if the serial numbers are already in a database with descriptions then why not have your users select the serial number from a picklist and then populate the description at that time.

In your case… the serial number field will need to make use of the onChange event in order for the dblookup to recalculate.

HTH

Mark

3

Subject: RE: Why isn’t @dblookup working?

I appreciate your thoughts about the @picklist but I have no experience doing that. However, I have the @dblookup working. The only problem now is if there are more than one descriptions, then they are all listed in the description field separated by a comma.

How would I go about only having one description listed even if there are 15 of the same description?

Thanks.