Hello Frank,
Frank Schönheit - Sun Microsystems Germany schrieb:
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".
Done
Create a grid with a list box column,
How can I do that? If I insert a table control, I get no "list box
column". Or do you mean the drop-down list, which is in the table view
of the form, if the form has a list box control?
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).
That should be no problem in this case. You can have a separate form for
entering new participants.
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.
I see. That's a nice way. It might be useful in some cases for 1:n
relations too.
Thanks for your help
Regina
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
