by UnklDonald418 » Sun Mar 05, 2017 1:39 am
With your main database window open select the Tables icon from the list along the left side.
Right-Click on the table "DVD-Collection" and select Edit from the pop-up menu.
Select “ID” from the list of fields, and look toward the bottom of the screen for the property settings. AutoValue should be the first entry, click on the down-arrow and select Yes. Click on the X on the top right of the window and answer Yes when it asks if you want to "Save the changes".
Now when you want to enter a new row of data the ID field will show <AutoField> and it won't allow you to make an entry in that field. Once you have entered data in the other fields and move the cursor to a new row it will automatically assign a value to ID and save the the data you entered in that row.
Let us know if this solved your problem or if you still need help.
P.S.
When using an Embedded database (it says that in the lower left corner of the database window) be sure to back-up your obd file frequently, I recommend after every session where you add new records. When using Windows either save the backup to a different drive, or if you only have one drive then use a slightly different name for the backup. There are situations where the database doesn't shut down properly and your tables can disappear! The crashes generally don't happen very often but it can be rather disconcerting when you find all your data tables have vanished. If/when it does happen a recent backup can make things less stressful.
Converting to a split database sidesteps that problem, but the conversion can seem daunting to someone new to Base. For a home dvd collection I'm not sure it's worth the effort, but you can find the procedures (yes, it's further complicated because there is more than one way) in the Base Tutorials of this forum. Either way you still should backup.
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.8 & LibreOffice 6.4.7.2 - Windows 10 Professional