BASE questions

classic Classic list List threaded Threaded
2 messages Options
Reply | Threaded
Open this post in threaded view
|

BASE questions

Mike Shearer
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




Reply | Threaded
Open this post in threaded view
|

Re: BASE questions

Alan Boba-2
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 <[hidden email]> 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