I create a new table using the wizard or in design view and all functions are greyed out and unusable - how to I change the properties so that I can enter records?
Hello,
Most probable cause is that you have not assigned a primary key to a table field. This is necessary in database tables for record creation.
Also, when asking a question, please include the specific LO version used, your OS and for Base the database used (there can be very many different ones).
Hi
Clearly not used to this Q & A system - I have an index and my first table only has 3 fields - all functions greyed out. What am I doing wrong?
btw
Windows 10 v 20H2 - Libre Office 7.1.0.3 [64-bit] - Base database is my first [puzzling] creation [after 20 years on MS Access]
@dibby444,
I hope you mean Primary Key and not index. Not clear as to what you mean by functions. As for the database in use, on main Base screen at the bottom (status bar) is the database used and the connection type.
May be best if you are really lost to post the Base file you have created. Edit your original post (edit in lower right of question area) and use toolbar (upper left in question area) paperclip icon to attach the file. See → How do I attach a file to my question/answer?
Hi again
Thanks for the update - reached me “late” and in bed. (UK is later that USA!)
Still fiddling around and found the answer, but still not sure how.
For “Functions”, read any drop down menu item.
Percy Vering
DB
p.s.
Can not add as an “Answer” as not sure how I did it, but I did - AND the Captcha selection screen goes on forever [Browser = Brave Version 1.21.74 Chromium: 89.0.4389.72 (Official Build) (64-bit)]