Help with replace content of field

[raymanj]

Need some help implementing an auto-enter field. When a user enters a product number or a catalog number into a item number field of a order form's portal, I need the field to replace the catalog number that was entered with a product number (if a match is found in inventory)

I have attached a sample file that I got some help creating in thread 173418. The file demonstrates how to do lookup from the product's table or the catalog's table, when a item number is entered.

Goal

I need some kind of auto-enter function or custom function that will replace any catalog number entered with its corresponding product number. But still leave any number entered alone that is not found in the catalog or product tables.

LookUpOr2.zip

Edited January 27, 2006 by Guest

[SlimJim]

I'm not sure if I have understood the question correctly but I have made a modification to the auto-enter in your file. Is that the sort of thing you are looking for?

LookUpOr2.zip

[raymanj]

I'm not sure if I have understood the question correctly but I have made a modification to the auto-enter in your file. Is that the sort of thing you are looking for?

Sorry, for not explaining it better. What you uploaded, did exactly the same thing the my functions did.

I need the "EnteredNumber" field's contents to be replaced with a corresponding product number, when a catalog number is entered. No replacement should occur, if a product number or some other number which is not in the product or catalog tables.

Here are the outcomes for a given input to the "EnteredNumber" field in the line items table.

• Input: EnterNumber = a product number, which exist in product table. Out come: EnterNumber = the same product number should still be in the enterNumber field.
  
• Input: EnteredNumber = a catalog number, which exist in catalogitems table. Out come: EnterNumber = the catalog number will be replaced with a product number that the catalog number matches, based on catalog items table.
  
• EnteredNumber = Some Number (Not found in the Product or Catalog table). Out come: EnterNumber = the some number should be left alone.
  

I hope this is a better explanation.

[comment]

See attached.

LookUpOr3.fp7.zip

[raymanj]

See attached.

Hey, it worked. I have been trying to get this thing to work for the last few hours.

I attached a modifed version. I wanted to keep the productID separate from the EnterNumber field, because I wanted to have the productID as a foriegn key in Line Items.

Thanks again, Comment.

LookUpOr3.zip