Ask Your Question

Can't enter data into Base forms. [closed]

asked 2014-03-15 22:10:32 +0200

this post is marked as community wiki

This post is a wiki. Anyone with karma >75 is welcome to improve it.

There is a blinking cursor indicating active fields, but I can't type into them. The cursor doesn't move. It seems to be read only, but there isn't anything to read (new database). Running Version under Mac/Mavericks.

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2016-02-20 07:54:28.967905

1 Answer

Sort by » oldest newest most voted

answered 2014-03-17 03:15:21 +0200

frofa gravatar image

updated 2014-03-17 03:20:36 +0200

Has your table got a primary key (PK)?

Database (Base) tables must have a PK to be editable. Usually the PK is an integer auto-value IDENTITY (ID) column which is needed to uniquely identify each row of the table. Open your EDIT TABLE window to check. See attached screenshot as an example. If your table does NOT have a PK, you will not be able to add any data to your table (either in the table listing or via a form). (Note: since you seem to have posted several versions of this question, perhaps you would delete the other ones.)

image description

edit flag offensive delete link more

Question Tools



Asked: 2014-03-15 22:10:32 +0200

Seen: 2,416 times

Last updated: Mar 17 '14