To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=53377
------- Additional comments from [EMAIL PROTECTED] Wed Sep 21 10:18:57 -0700 2005 ------- More info from the second person reporting problems : Employees table ID Integer [INTEGER] This has Autovalue = Yes FirstName Text [VARCHAR] LastName Text [VARCHAR] key_employeess Integer[INTEGER] Autovalue = No, Entry requiered = Yes Events table ID Integer[INTEGER] Autovalue = Yes EventDescription Memo[LONGVARCHAR] EventTypeID Integer[INTEGER] Entry required = Yes key_events Integer[INTEGER] Entry required = Yes In the Tools, Relationships window, we have Employees Table and Events Table. ID.Employees is connected to key_events.Events which appears to be a one-to-many relationship and i have checked the boxes Update Cascade and Delete Cascade. The Design View was used to make the Query_Employees. i just put both tables on the palette, linked the same fields again (ID.Employees and key_events.Events), pulled each of the field names onto the grid below until all of the fields were represented on the grid, clicked the Save button on the upper lefthand corner of the Design View and finall clicked on the RunQuery button. The query runs, and puts all of the field names up at the top of the page, but there is nothing below any of the fields to fill in. Alex --------------------------------------------------------------------- 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]