Easiest method is to define a lookup field and set the options to "Help &
Fill", and if the descriptionis to be entered into the current table, set
"All corresponding fields" on. This makes the lookup table available for
those times that you can't remember the code, as well as filling in the
fields.
If you don't need to store the description, set "Just current field" on. To
display the description on your form, you'll need to add the table
containing the product codes & descriptions to your data model, and link it
to the table you're entering the codes into. Link using the code field,
which should result in a 1->1 link, which will allow you to display fields
from both tables in a record object (within a table frame or MRO).
Bob
Quote:
> I have an application that when a user enters a product code in a
UIObject
> on a form, the product code needs to be matched up with a product
> description with the same product code, and both the product code and
> product description needs to be displayed on the form. Does anyone know
> how to accomplish this?
> Regards
> Joe