Distinct
Thank you very much
DISTINCT seems to have solved the issue!
heres my sql in case anyone finds it useful
SELECT DISTINCT *
FROM member, locations
WHERE locations.member_MemberID = member.MemberID
so each record in member is unique, but each member can have many locations records to acheive a search by location, for member I joined the tables in the record set, but came back with multiple results for each member the Suggested use of DISTINCT pulls only one.
thaks so much, Ill explore those other suggestions as well.