Hi Regina, > See http://www.rhenschel.homepage.t-online.de/tinyexample.odb > You should open the tableview of the form in addition to see the whole > table content.
Hmm. The fact that the list box content is not even displayed as expected already shows there's something strage. Dropping the relationship, and changing the "Group" column of "withforeignkey" to be of length 50 (instead of 2) "solves" the problem in that updates are now possible. However, the wrong values are written into the "source" table then ... What's obviously going on here is that the "bound column = 1" property of the list box evaluates to the colum no. 1 of table "source", with counting starting with 0 ... So the list box reads from the "source.leader" column. And values from this column are then written into "withforeignkey.Group". This fails in your original form setup since this column allows only 2 characters. Fixing this in the form would require to set "Bound column" to 0 instead of 0 - which, strange enough, is rejected by the UI. Overall, I see a number of problems here, not all really related to your immediate problem - The error message could be improved - changing a column length which is part of a relationship is currently prevented - why, really? - the UI doesn't allow to set a "Bound column" of "0". Alternatively (and the code looks like this was originally intended): The column counting should start with 1, so that a "Bound column = 1" really means "the first column", not "the second column". - "Table" is halfway senseless as table source, since the "Bound column" is index-based, but it's completely undefined in which order a database returns the columns. I.e., if you do a SELECT * FROM <table>, orders might in theory appear in any order. - Both the "bound" and the "displayed" column should be chosen by name. Currently, the bound is chosen by index (which is senseless as outlined above), and the displayed column is always the first one (with index "0"). I'm going to submit some issues. For the moment, I can just suggest using the "SQL statement" option in the list box setup. 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]
