Searching for records across two tables using a form

A

alan newton

Hi folks,

Hope someone can help me with this one. I have two tables delegates and
aka. The two tables are related via an id field. The delegates table
contains, first_name, surname, and middle_names amongst other, while the aka
table contains fields aka_firstname, aka_surname and aka_middlenames.

I need to create a form with will search across the two tables and display
the results from the delegate table if there is a related record in the aka
table as well as if there is a result from the delegates table. (sorry that
doesn't read very clearly.)


Any advice on how this could be achieved would be appreciated.

Kindest regards,

Alan
 
Top