automatical update of fields, many-to-many relationship

automatical update of fields, many-to-many relationship

Hello People,

I have following application where I want to link instructors with courses.
The application consists of 2 tables:

Table A : List of courses
Table B: List of instructors

In the first table I inserted all the possible courses myself and I don’t want a public form.
For table B I want to send a form to the instructors, where they can insert their name and the courses they want to hold. This can be 0 to many courses. I used a lookup field with multiselect to get the information from table A.

Now what I need in table A is the list of courses also with all the corresponding instructors for each course. Is it somehow possible to update the field “list of instructors” automatically?

I´m very happy for any suggestions! Cheers a lot!

PS: I made my "test" application public, to help understand what I mean:
http://creator.zoho.com/flo_av/test-instructor-and-course/

flo_av