Linking two fields with different names in one table to another table

[Niasha231]

I have the following tables:

(tlbJudgments) with fields, "Plaintiff" and "Defendant"
(tblProperty) with fields, “Grantor” and “Grantee”
(tblIndividuals) with fields “FirstName”, LastName” “Address” etc

It is possible to link the fields Plaintiff and Defendant to the individual table and if so how? Same goes for the Property table. Any suggested way of dealing with the above would be greatly appreciated.

Thanks in advance.

[Rabbit]

Is your question how to join tables in general? In which case, I suggest a SQL tutorial because that is one of the basic functionalities you should learn. A good tutorial can be found here: http://www.w3schools.com/sql/sql_join.asp

Or is your question about how to join two different fields to the same table? In which case, you do it the same way you would a normal join, except you do it twice. You bring in the individuals table two times and give each reference a different alias. Each time you join to a different field.