lookup field with duplicate entries then select one or another to obtain corresponding record information
Hi hope someone can help
I have a form (CONTACT INFO) which has first name, last name, email, country
Duplicates are allowed for last name
(example entries would be)
Jon Smith jon@test.com India
Jon Smith (no email) USA
Jon Smith jon@abc.com USA
fred Smith fred@abc.com USA
I have another form (book_contact) which looks up surname,
I get 4 occurrences of "Smith" which is ok
Problem
I want to be able to select each smith in turn and fetch the related info to make sure i have the correct smith.
I tried using fetch record but always get the same smith, tried using For Each record but end up getting all the Smiths
I just want to select each Smith in turn show related fields from the record and when i have the correct smith , perform some other actions
Thanks