CompuServe Messages

#SB Personal Questions

    27-Dec-89 00:14:24
Sb: #SB Personal Questions
Fm: Joel Halbert 73147,353
To: SPC Superbase Tech Supp 76004,2300
Hello. I just received Superbase Personal (as a gift), and I want to set up a simple "inventory" style database for a collection of antiques. I have several questions at this point, and I'd be most appreciative if anyone can help me. If the answer to any of the following involves upgrading to a higher version of Superbase, then please be specific as to the version required and the method used to solve the problem. Thanks very much! 1. Several fields in each record represent categories, and therefore should be restricted to one of "n" preselected choices (e.g. china, glassware, silver or furniture). I can see that it is possible to use a validation formula to restrict the possible entries, but I'd like some way to prompt the database user with a list of the possible choices as he/she makes the entries. Is this possible? 2. According to the manual, text fields are limited to a maximum of 255 characters, and apparently there is no simple way to have multiple-line fields. I need to include descriptive language in certain fields, so I'd like to figure out a way to handle more text. It seems that the external file feature only works for IFF pictures, despite the statement in the manual that says they can also be text files. I also need a way to control the printed format of the text blocks. Any suggestions? 3. Is it possible to have records whose structure changes depending on the value of one or more controlling fields? For example, different information is needed to describe a teacup as compared to a cabinet. I can see how to accomplish this (sort of) by using multiple related files, but I'd rather not have to deal with that unless the appropriate file is accessed automatically based on the value of the controlling field(s). Thanks again for any and all advice. Joel Halbert