Lookup with multiple field information

Lookup with multiple field information

First off,

Thank you so much for a great application and all your outstanding support. I love it!

I have a membership database with three forms: a member form where personal information is stored, a club form with information on sports clubs, and a participation form which tracks a members participation in a club.

I would like to do a member lookup from the participation form, but I will need the lookup to show multiple information to avoid selecting people with the same name (ie Surname + First Name + Sex + Date of Birth). Any idea on how to do that?

Cheers,

Dave