[Solved] Problem in direct data entry

Creating tables and queries
Post Reply
User avatar
meeranair2020
Banned
Posts: 11
Joined: Thu Jun 04, 2020 5:07 pm

[Solved] Problem in direct data entry

Post by meeranair2020 »

Sometimes, after creating a table in Design View, I am not able to enter records into it directly. Records can be entered using SQL without any problem. What may be the reason of this issue?
Last edited by meeranair2020 on Wed Nov 04, 2020 7:43 pm, edited 1 time in total.
Open Office 4.1.7, Windows 10
Top
User avatar
Villeroy
Volunteer
Posts: 31279
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: Problem in direct data entry

Post by Villeroy »

The table is lacking a primary key.
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
Top
User avatar
meeranair2020
Banned
Posts: 11
Joined: Thu Jun 04, 2020 5:07 pm

Re: Problem in direct data entry

Post by meeranair2020 »

I have a primary key for the table. Still, the problem continues.
Open Office 4.1.7, Windows 10
Top
UnklDonald418
Volunteer
Posts: 1546
Joined: Wed Jun 24, 2015 12:56 am
Location: Colorado, USA

Re: Problem in direct data entry

Post by UnklDonald418 »

Rather than guess what might be wrong with your table, please upload a sample database with the troublesome table.
[Forum] How to attach a document here
If your problem has been solved, please edit this topic's initial post and add "[Solved]" to the beginning of the subject line
Apache OpenOffice 4.1.14 & LibreOffice 7.6.2.1 (x86_64) - Windows 10 Professional- Windows 11
Top
Post Reply

Return to “Tables & Queries”