If not unique, show the existing record

[jiehuang001]

I am creating a database for inventory. The first field is bar-code, which will be scanned in. Apparently, this field will be unique since each item has a unique bar-code number.

Right now, when I am trying to add an item whose bar-code id already exists, a message will pop up saying that this field must be unique, and then I can choose to revert the field or not.

Is there a way to show the existing record instead of just showing such a message when adding an item whose bar-code already exists? In a word, if unique, add a new one. If not unique, show the existing one.

Thanks.

Jie

[Søren Dyhr]

It's pretty forward with a selfjoin - investigate the template. But but ....Where I smell trouble is the catching of the char that makes the trigging of the script ...where portals got the feature well not by default but as an option. So tabbing inside the portal eliminates the need for an event trigger to make each record split from the previous one, but here should a specific chars entry trig the next revolution of the script.

This talks for putting a call for a plugin inside a valuation calc.

--sd

theWorks.zip