To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=64898 Issue #:|64898 Summary:|show referenced record in subform for new record in |main form Component:|Database access Version:|1.0.0 Platform:|PC URL:| OS/Version:|Windows XP Status:|NEW Status whiteboard:| Keywords:| Resolution:| Issue type:|ENHANCEMENT Priority:|P3 Subcomponent:|none Assigned to:|dbaneedsconfirm Reported by:|regina
------- Additional comments from [EMAIL PROTECTED] Fri Apr 28 16:31:57 -0700 2006 ------- I've got a n:m-relationship, which is split into the tables: Kurse: KursID (primary) | Thema | Dozent Teilnehmer: KdID (primary) | Name | Geburtsdatum | Vorname | weiblich wer_was: wer (compound primary; reference to Teilnehmer.KdID) | was (compound primary; reference to Kurse.KursID) I create a form “Belegung mit Kontrolle” (see attached document) for to insert new records into the table wer_was. It contains a listbox for entering a value into wer_was.wer, which shows Teilnehmer.KdID. For checking whether I choose the right KdID, my form has a subform on Teilnehmer which shows the referenced record. If you open the form and browse the records with the form navigation, you see the referenced records in the fields of the subform. But if you will enter a new record in wer_was and have chosen a value for wer_was.wer, then these field of the subform are empty. RFE: If the field in the main form has a valid value, then the subform should show the referenced record although the value has not been transmitted to the database yet. --------------------------------------------------------------------- Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]