How to make a Unique ID

[Filipe]

Hello to all this is my first time to erery thing lol

Need info about this

I have i'm my db a field how is a phonenumber (number ) for user to place whem he fills the record the problem is that I have almoust 250 record's , and specially the are repeated , and wich to know how can I avoid that kindo of situation and make a script to permits the user , whem he's filling the form to check the phone number or name or SSN and if exist make a box to tell the user that the person allready exist's and don't save if ot fill's the form and save the record

Please help me , I'm really a newby on this

thanks

neomag

ps. sorry about the english

[QuinTech]

Hi, Filipe. No problem about the English. You speak English much better than i speak your native language, i guarantee.

What does a record represent? Is it an invoice, or a contact, or ... ? It sounds like you should create a separate table for People and relate it to the existing table. That way, you can have fields automatically filled in for each new record with the correct phone number for the person.

Jerry

[transpower]

Make the phone number and SSN fields unique: Define Field | Validataion | Unique value.