Bug 97643 - Cannot insert a new record within a table or create a relationship (FK/PK) between two fields
Summary: Cannot insert a new record within a table or create a relationship (FK/PK) be...
Status: RESOLVED NOTABUG
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Base (show other bugs)
Version:
(earliest affected)
5.0.4.2 release
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2016-02-08 12:17 UTC by Jonathan Camilleri
Modified: 2016-02-09 09:43 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:


Attachments
attachment (60.37 KB, application/vnd.sun.xml.base)
2016-02-08 12:17 UTC, Jonathan Camilleri
Details
screenshot (41.27 KB, image/jpeg)
2016-02-08 12:19 UTC, Jonathan Camilleri
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Jonathan Camilleri 2016-02-08 12:17:57 UTC
Created attachment 122437 [details]
attachment

I created a new table named 'payment-agent' but I have no way of inserting a new record or creating a relationship between entity.payment-agent-id and payment-agent.payment-agent-id.
Comment 1 Jonathan Camilleri 2016-02-08 12:19:50 UTC
Created attachment 122438 [details]
screenshot
Comment 2 Jonathan Camilleri 2016-02-08 12:29:23 UTC
Comment on attachment 122438 [details]
screenshot

No option to edit or insert visible, is this due to the maximum length that a fieldname can have or the special characters?
Comment 3 Robert Großkopf 2016-02-09 09:43:48 UTC
Hi Jonathan,

you have forgotten to declare a primary-key. Open the table for editing, right mouseclick on the row-header of first column and choose "primarykey".

By the way: Is it right you declared all fields as varchar-fields? Aren't there any numbers?

This isn't a bug, so I will set this to "Resolved → Notabug"