Hi, On Tue, Oct 21, 2008 at 9:19 AM, Owen Leonard <[EMAIL PROTECTED]> wrote: > I would think there should be an auto-incrementing numeric id in the > borrower_attribute_types table for each code which would get entered > into the borrower_attributes table. Then you could freely edit > "code"'s value without having to worry about updating every line in > borrower_attributes.
code is the primary key of borrower_attribute_types, and there is a foreign key relationship between borrower_attributes.code and borrower_attribute_types.code set up to cascade updates. This means that if you change a code value in borrower_attribute_types, the change will automatically propagate to affected borrower_attributes rows. I believe the user interface currently prevents one from changing the code, but I did that mostly to avoid having to handle several error reporting scenarios. Regards, Galen -- Galen Charlton VP, Research & Development, LibLime [EMAIL PROTECTED] p: 1-888-564-2457 x709 skype: gmcharlt _______________________________________________ Koha-devel mailing list Koha-devel@lists.koha.org http://lists.koha.org/mailman/listinfo/koha-devel
