[libreoffice-users] Re: LO Base Problem

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+unsubscribe@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