Problem in direct data entry

Creating tables and queries
Post Reply
megha bhavsar
Posts: 1
Joined: Mon Nov 23, 2020 11:40 am

Problem in direct data entry

Post by megha bhavsar »

i am not able to enter record after making table in design view. the edit data icon isnot activated. The table has primary key too, Is it related to Table name or something?
Attachments
Grade X.odb
(2.63 KiB) Downloaded 230 times
Open Office 4.1.8 Windows 10
UnklDonald418
Volunteer
Posts: 1547
Joined: Wed Jun 24, 2015 12:56 am
Location: Colorado, USA

Re: Problem in direct data entry

Post by UnklDonald418 »

Base tables without a Primary Key are read only. The SDetails table you uploaded does NOT have a Primary Key, I copied your table into SDetails01 and added a Primary Key with the Auto Value property set to Yes, and now data entry is possible into SDetails01.
Forms allow far more formatting options than using the Table View GUI, so I created a Form document also named SDetails01.
Attachments
Grade X_mod01.odb
(12.71 KiB) Downloaded 199 times
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
Post Reply