#Index on Multifields
29-Oct-90 23:16:27
Sb: #19671-#Index on Multifields
Fm: Mark Olbert 73557,1512
To: Russ Witt 76625,20
Russ,
I'm not employed with Precision, but I have been mucking about with
Superbase for a few years on the Amiga.
I don't think multifield indices are 'aware' of anything other than the
first entry in the field. I say this because I've never been able to get
the report generator in Superbase to recognize the existence of entries
'above' the first one.
So far as popup lists are concerned, have you tried requestor type 20? It's
syntax is REQUEST "Line1","Line2",20,Resp%,TargetField,len%,Field2,
Field3,Field4. Line1 and Line2 are explanatory text. Resp% holds the
response code (1=OKAY clicked, or a selection double clicked, 0=CANCEL
clicked), TargetField (which can also be a variable) is where the result
gets put, Field2 is what you pick and Field3 and Field4 are additional
fields from the same file as Field2 which let you 'explain' the Field2
values.
I use this type of request a lot when I want to make pick lists. One thing
that's not terribly clear in the manuals: once the requester appears, you
can enter a partial key values in the entry box, hit return, and have the
requestor move the pick list to the nearest matching key value.
– Mark