Hello Mike, Don't have all your answers off the top of my head, however for an auto incrementing id use field type Integer with Autovalue set to YES.
On Mon, Jul 29, 2019 at 4:03 AM Mike <mike.shea...@westnet.com.au> wrote: > I'm new to Base and discovering just how ignorant I am despite 40 years > working in IT. I have created a simple data base with three tables. > When trying to create relationships and forms it's become obvious that > some of my field definitions need to be changed. Problem 1: how can I > display all of the variables I used to specify each field? Problem 2: > I created a table and made a mess of it. How can I delete that table? > DROP TABLE ... hasn't worked. Problem 3: The ID in my main table is a > numeric sequential number. Can I define the field so that the number is > automatically assigned using a field type? > > Background: I'm working in OpenOffice 4.1.6 on a MacBook Pro running > MacOS 0.13.6. My first reference is to LibreOffice 4.0 Base Handbook, > OO helps, OpenOffice Forum, then finally Google. I assume that > LibreOffice BASE and OO BASE are sufficiently similar that LO > documentation should be relevant to OO BASE. > > thanks, > > Mike Shearer > Australia > > > > > -- Alan Boba CISSP, CCENT, ITIL v3 Foundations 2011
