Help with Field Values 
Author Message
 Help with Field Values

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



Wed, 06 Oct 1999 03:00:00 GMT
 Help with Field Values

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

As I understand it, the product code you are trying to match is part of
the product description.  I would use locatePattern()

Al Solter



Wed, 06 Oct 1999 03:00:00 GMT
 Help with Field Values

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



Thu, 07 Oct 1999 03:00:00 GMT
 
 [ 3 post ] 

 Relevant Pages 

1. Help:Editing field values of an ADO recordset returned from SQL SP

2. Help: Editing field values of ADO recordset from SQL db

3. Help with field value changing

4. Help getting Field Value

5. adodb connection to excel: recordset.fields(i).value=null for fields with numeric value

6. Incrementing Next Field's Value Based Upon Prior Field's Value

7. Help with listing Universe multi-value field and single field

8. Check for NULL field value without returning field value

9. Help me get the last value of autoincrement field

10. Help with ADO Recordset when field value contains quotes

11. Help to set local variable equal to value of field in result set

12. Help with getting numeric total value of fields in a row


 
Powered by phpBB® Forum Software