Hi,

I am trying to work out a solution in a simple test application. I have three forms, Student, Class and Booking. There are M:M bidirectional relationships between Student:Booking and Class:Booking.

In each of the Student and Class forms I have a Booking subform. i.e. In the Student form I have a subform that is supposed to list the classes the Student is registered for, and in the Class form there is a subform showing the Students that are registered. This seems like it should work. However, if I add a row from the Student record, I can select a Class (Student is not displayed). A Booking record is created but the Student is null. This totally throws me.

I have tried running the following script in the On Row Add event of the subform:

It runs and the correct Student ID is showing in the info message, but when I look at the record that is created the Student value is blank again.

Am I going about this in completely the wrong way? Any help gratefully appreciated.

JP