OpenOffice database

  Simsy 13:40 19 Dec 2007


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 2007



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

Elsewhere on IDG sites

AMD Ryzen news - release date, UK price, features and specifications

The pulp art of 80s computer game magazine covers

Best value Mac: Which is the best £1249 Mac to buy

Comment faire des captures d’écran sous Windows 10 ?