#SuperBase Pro 4 Question
31-May-93 21:27:36
Sb: #57900-#SuperBase Pro 4 Question
Fm: Ken Roberts 70027,2136
To: Neil Robinson 100016,2775
Thanks, Neil. But what would I do if, say, I wanted to look at the field that
has multiple entries as a whole? From what you suggested, it seems that each
response is treated like a separate field. Can't I look at all the entries and
search for one attribute?
For instance, if a multiple response field was for categories for a movie, I
would like to be able to enter both "Comedy" and "Social Commentary" as
separate entries in that field, and be able to sort so that the movie would
appear under both the "Comedy" and "Social Commentary" listing.
If it is an array, I should somehow be able to look at all elements at once and
pull that information as needed (for instance, if any(category =Comedy then
[D=Comedy then yes else no) or something like that. But that would be more in
the programming language, rather than in a simple query, right?
Thanks===
===Ken