jeffl@nc386.uucp (Jeff Leyser) (08/15/89)
I have recently been asked to do some maintenance on an existing R:BASE system. While I have a good amount of experience with databases in general, my R:BASE experience is mostly limited to the EXPRESS programs, and I now find myself needing to do some "true" coding in R:BASE. And I could use a little help :^) The biggest problem I'm facing right now is the creation of a "zoom" list. That means that when a user enters a field on a data entry form, I want to have a list of valid values for that field appear. The problem is that the list of valid values is not static (it's a list of building tenants, and needs to be updated when people move into the building). If it were a static list, I would just use the CHOOSE command and have a menu prepared. But the list of tenants is actually a column of data in a table. Is there an easy way to create a menu of this data? I'm thinking right now of dumping the data to an ASCII file, and then using the CHOOSE command on it, but that means I need to provided for the maintenance of the ASCII file, and I would also need to split up the data, as there is too much to put on one CHOOSE menu! Has anyone ever done something similar to this? -- Jeff Leyser ...!uunet!hal!ncoast!nc386!jeffl