Duplicates Issue

This topic is locked

Duplicates Issue	4/29/2011 4:09:43 AM
PHPRunner General questions
A angelcause author I am designing a profile database where i have fields NAMEand FATHER NAME. Now i want help in making such a query which will not allow the same record to be entered again in the profile by checking the NAMEand FATHER NAME fields together if they r not repeating. e.g. It may be possible that there are two boys by the name of "JOHN" but surely their fathers name can not be the same. So i hope u got me. Thanks a million in ADVANCE


J	joker 4/29/2011
	I am designing a profile database where i have fields NAMEand FATHER NAME. Now i want help in making such a query which will not allow the same record to be entered again in the profile by checking the NAMEand FATHER NAME fields together if they r not repeating. e.g. It may be possible that there are two boys by the name of "JOHN" but surely their fathers name can not be the same. So i hope u got me. Thanks a million in ADVANCE On the PAGES tab of PHPRunner select your table and choose both NAME and FATHER NAME as your key column for that table. You can choose up to three columns to create a key for your table. From the manual - "The values that compose a key column are unique; no two values are the same"