What is the best way to have a 3rd list using data from other 2 lists?

[jmdc]

Hello,

I would like to know if it?s possible to have a 3rd list working trought other 2 lists:

My 1st list elements (students):
Student name | Age

1. Robert | 18
2. Ana | 25

My 2nd list elements (parents):
Parent name | Mother or Father | Student name (databasejoin 1st list)

1. Guy | Father | Robert
2. Maria | Mother | Robert
3. Isabel | Mother | Ana

In my 3rd list (items to pay), i would like to have:
Student name | Mother (only mothers) | Itemid1 (yes/no) | Itemid2 (yes/no)

1. Robert | Maria | Yes | No
2. Ana | Isabel | Yes | Yes

This list must be automatic (Student name and mother from the other 2 lists)...User will just have to insert Yes/NO in Itemid1/2 (using inlineedit for example).

Could you help me to achieve the best way to have this 3 list?

Thank you.

 

[cheesegrits]

How would the "student name" be automatically filled in? Would you be opening the form from the Student list, or from a J! menu item linked directly to the form and you base the student on the logged on userid?

-- hugh

 

[jmdc]

I have found a solution that can work...
I will create the 3rd list from the student table (wich is filtrering based on the logged userid) and i will put an INNER JOIN...like

From: Student
To: Parents
From column: Userid.Students
To colum: Userid.Parents.

And it works like that....i think..