Hi Regina, > I have written http://www.openoffice.org/issues/show_bug.cgi?id=64898
Thanks. > I think, that it will not work for entering new records into the wer_was > table. Because it has a compound primary key, it needs a valid reference > to 'Kurse' and a valid reference to 'Teilnehmer' at the same time. I > cannot make 'Teilnehmer' or 'Kurse' to master, because 'wer_was' would > need to be subform to both at the same time. In addition, how will you > make 'Kurse' master to 'Teilnehmer' or v.v.? There is no direct link > between them. Make "Kurse" the main form. Create a sub form, bound to wer_was, connecting from "kursID" to "was". Create a grid with a list box column, or a list box control. Bind it to the "wer" field of "wer_was", and a "SELECT Name, KdID from Teilnehmer". This gives you a main form for the courses, and a sub form where you can enter new participants, selecting from a list box. Unfortunally, you cannot enter new participants (this would require a combo box with some kind of "Not in list" event). The trick here is that when you enter a new record in the sub form, the "wer" part is taken from the connection to the master form (i.e. "Kurse"."kursID"), and the "was" part is taken indirectly from the name you enter. >>Else, a macro on the "After record action" event might help - you could >>reload the sub form therein. > > I feared that. In general, standard demands on the database system > should be fullfilled without macros. But I'm hopeful. Base is a new > modul and it will become better in each release. Thanks for your confidence :) Ciao Frank -- - Frank Schönheit, Software Engineer [EMAIL PROTECTED] - - Sun Microsystems http://www.sun.com/staroffice - - OpenOffice.org Database http://dba.openoffice.org - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
