Unique Key creation

[Former Member]

Hi gurus,

Can anybody help me out in creation of unique key table. My problem is if suppose say country is there as a field and in that field i have to enter 10 entries say hyd, bbsr, chennai...my problem is say if i enter bbsr and the next time if i wrongly enter the bbsr again then the system should promt entery already exist. And one more thing there should not be any foreign key relation with the table, i can create foreign key relation but with out that.

I just want to know can we give that unique key to the field.

so that the entries that we are give should not be repeated.

Please help out its very very urgent for me.

Thanks in Advance.

[mahaboob_pathan]

hi,

while creating the table

select both the check box's in data element

when u enter the field name.

and save and activate it.

[Former Member]

hi,

u can do it by eithr way u may click check box in front of field while creating table and activate it so that field is declared as a key or when u using that table in ur program while declaring that table in data declration explicitly declare that field as key by writing AS KEY FIELD.. in front of the declaration of table

thanks

Please give points