Bug 144841

Summary:	Design View Interface doesn't allow multi-selection necessary for multi-field primary key
Product:	[Applications] KEXI	Reporter:	Matthew Swaringen <xanas3712>
Component:	Tables	Assignee:	Jarosław Staniek <staniek>
Status:	CLOSED DUPLICATE
Severity:	wishlist
Priority:	NOR
Version First Reported In:	1.1.2 (KOffice 1.6.2)
Target Milestone:	---
Platform:	Gentoo Packages
OS:	Linux
Latest Commit:		Version Fixed In:
Sentry Crash Report:

Description Matthew Swaringen 2007-04-29 23:11:39 UTC

Version:           1.1.2 (KOffice 1.6.2) (using KDE 3.5.6, Gentoo)
Compiler:          Target: x86_64-pc-linux-gnu
OS:                Linux (x86_64) release 2.6.21-rc7

Sorry for severity description if no one agrees that this applies, but I think it does so I am filing this as a bug because it's a major interface flaw.

The shift and control keys can apparently not be used in design view for a table to select multiple fields to set a primary key.  And honestly, I couldn't figure out how to do this from a search of google/etc. either so I'm confused as to even how I can do this at all in Kexi.  This is not a good situation to have a basic feature such as multiple-field primary keys require extensive research to perform (I still don't know how to do this).  Almost every table I use at work requires this feature.  We use access/microsoft software, but if Linux/KDE/etc. is ever to overcome barriers it will require that useability requirements are as high as possible.

Comment 1 Jarosław Staniek 2007-04-30 04:26:54 UTC

Thanks for reporting. Changed severity to a wish. Multi-column PKs are planned for Kexi 2.x where x is probably > than 0. 
Until then, there will be additional (read: more complex, affecting many parts of the application) GUI tab for advanced users, for defining complex indices, and in particular, primary keys.

While I value feedback from advanced users, so far a need for multicolumn PKs was not #1 requirement (comparing to other requirements); if you badly demand this, consider supporting the project (there are many ways). 

Please feel free to report more wishes - all of them are kept carefully in this bugsystem.

Regarding "figuring out how to do this" -- all the features are presented in the Kexi dev. wiki [1], and most features are described in the docs as well.

[1] http://www.kexi-project.org/wiki/wikiview

Comment 2 Matthew Swaringen 2007-04-30 04:56:19 UTC

That'll work for me.

Thanks for the response.  This wasn't a request I had regarding 
something I needed, but I do think if others are to want to use Kexi 
instead of alternatives like Microsoft Access (what I use at my job) 
this feature will be needed.  Since it's a planned addition in the 
future it's good to hear it'll be resolved down the line.  I wish that I 
were in a position to do some kind of help here but I thought this 
feature important enough to bring up since I didn't see another open bug 
for it.  I'm not a programmer but I have made a donation to kde in 
general in the past, and plan to do so again.  If I find other ways to 
help that I can do I'll be sure to do so.  

Thanks for the link to the resources.  I wasn't able to find out how in 
the kde help center kexi page (maybe didn't look long enough or in the 
right places)

Jaroslaw Staniek wrote:
[bugs.kde.org quoted mail]

Comment 3 Jarosław Staniek 2007-04-30 10:41:28 UTC

OK, great. 
If Kexi manual is packaged in your distibution, it's available available online at http://docs.kde.org/stable/en/koffice/

More info: http://kexi-project.org/support.html

Comment 4 Jarosław Staniek 2012-08-11 12:19:28 UTC

More description added for wish https://bugs.kde.org/show_bug.cgi?id=277435. Closing this report as a duplicate.

*** This bug has been marked as a duplicate of bug 277435 ***