Le 18/02/2015 15:23, Ian Whitfield a écrit : Hi Ian,
> > Yesterday I found I had not set my Keyfield (RecordID) to Auto Increment > so I set a new field with phpMyAdmin called 'id'. And this is now > working fine and Auto incrementing. I deleted the old RecordID field. Why did you do that ? Why not just alter the existing Keyfield (RecordID) to autoincrement ? When you talk about the Keyfield, do you mean that this was a PRIMARY KEY or was it a reference for other tables (FOREIGN KEY)? Did you attribute PRIMARY KEY status to the new field that you created? Did you recreate any references (FOREIGN KEYS) to other tables ? If you didn't, then by deleting your original RecordID field, you probably deleted the primary key and/or any references as well, and in all likelihood that is the reason why the forms that relied on that key to be set no longer work. This is all a guess though without knowing exactly how your original RecordID field was defined and whether or not it had any relationships to other tables. Alex -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
