Sir
I have 1 master tables named as statemaster
and it has 2 fields
stateid and statename

and i have a detail table named as
detaildragon

my question is should i add stateid,statename on this table also,so is it help me for searching purpose.
if the records exceeds a particular limit say 500000.

pl'z help me

thanks in advance
PrasantH