OpenOffice database

  Simsy 13:40 19 Dec 07


I hope someone can advise on how to do this. I'm trying to learn how to do something in OpenOffice, so I can show someone else how to do it!...

I've a simple database, just one table. I've created it but there are two things I'd like to be able to do, if possible;

1) One of the fields is set to be "Boolean", because it can only have one of two values. Can I set this so that the two values are two different text strings, i.e. "Main" and "Table", or does it have to be a yes/no via a tick ?

2) Another field I want to restrict to any of 3 possible text values. Can I do this, either in table data entry, or via form entry? Perhaps via a "dropdown" as per data validation, via a list, in Excel?

(I realise that the answer to the first may be to use the solution to the second question... whatever that is!)

Thanks in anticipation.



  Simsy 01:11 20 Dec 07



This thread is now locked and can not be replied to.

Huawei P10 review

1995-2015: How technology has changed the world in 20 years

How VR is being used to simulate space

New iPad, iPhone SE & Red iPhone 7 on sale now