>Suppose the countries table has two fields namely CountryID, and CountryName.
>Suppose the states table has two fields namely CountryID, and StateName.
>
>SELECT CountryID, StateName, COUNT(Statename) FROM Country INNER JOIN State ON Country.CountryID= State.CountryID GROUP BY CountryID, Statename INTO CURSOR CountState
>
>
>Use the table entitled CountState to determine whether or not a state is unique within a given country
Thanks Dave, but I would like to know if there is any "ready" method, like lUnique, cView and cViewParameter.
Regards,