AnsweredAssumed Answered

Auto-Enter looked-up value, frustrating results

Question asked by ianmanning on Jun 15, 2010
Latest reply on Jun 16, 2010 by ianmanning

Title

Auto-Enter looked-up value, frustrating results

Post

In my line items table I have 3 fields which use Auto-Enter looked-up values

The 3 fields each get their values from a price list table

The fields are Part Number, Part Description and Price

 

Field PartNumber lookup based upon the relationship matching the entered PartDescription.

 

Field PartDescription lookup based upon the relationship matching the entered PartNumber

 

Field Price lookup based upon the relationship matching the entered PartNumber

 

So if either the PartNumber or PartDescription is entered the other field will be entered automatically. This works great however the price field only works if the PartNumber is entered it remains blank if the PartDescription is entered.

I assume the process which stops the two fields endlessly causing the other to be looked up, is the reason that the Price is not looked up if I enter the PartDescription.

 

Is there a simple way to get the price to lookup. I am trying to avoid using Record Relookup field contents as the fields are in a portal so I would have to switch layouts to the LineItems and find the correct record(s) every time I add a new line item in the portal.

 

Thanks in advance for your help and Ideas

Best regards

Ian

Outcomes