Hello All,
I am interested in doing a simple query with multiple choices.
Example:  I have one data base with SPEAKER, ADDRESSEE, DATE, SPEECH fields.  
I
have a set number of speakers, so I wish to be able just to choose from a 
list of names instead of having to type it in every time.
Also, I wish to be able to cross reference words in the speeches.  Instead of 
typing ..word.. in the query is there any way just to get it to ask me which 
word I'm looking for?
End run, I would just like to have something like the OBEX address book with 
pull down menus for someone else that has zero understanding about databases.
Shawn AKA WATCHMAN
|TEAM OS/2| Reaching to the top
---
(1:3623/1)
---------------
** A related thread FOLLOWS this message.

FIDO MESSAGE AREA==> TOPIC: 119 PARADOX       Ref: CC2R0443 Date: 08/02/95
From: CRAIG WELCH                                           Time: 10:07pm
\/To: SHAWN WILKERSON                                     (Read 5 times)
Subj: R: PDOXWIN 5.0

SW>Hello All,
SW>I am interested in doing a simple query with multiple choices.
SW>Example:  I have one data base with SPEAKER, ADDRESSEE, DATE, SPEECH fie
SW>I
SW>have a set number of speakers, so I wish to be able just to choose from 
SW>list of names instead of having to type it in every time.
SW>Also, I wish to be able to cross reference words in the speeches.  Inste
SW>typing ..word.. in the query is there any way just to get it to ask me w
SW>word I'm looking for?
SW>End run, I would just like to have something like the OBEX address book 
SW>pull down menus for someone else that has zero understanding about datab
SW>Shawn AKA WATCHMAN
SW>|TEAM OS/2| Reaching to the top
SW>---
SW>(1:3623/1)
It sounds like you'd be better off creating a form. By using a pushbutton,
you could grab the search values from fields on the form for your query,
fill in the query and use the ExecuteQBE (doing it from memory) command
to extract the data. You can add a menu to the form for ease of use.
 
Look in the objectpal books.
 
Good luck,
Craig.
---------------
>>>>>>>>>>>>>>>>>>>>>> LAST Message In Thread <<<<<<<<<<<<<<<<<<<<<<

FIDO MESSAGE AREA==> TOPIC: 119 PARADOX       Ref: CC200001 Date: 08/01/95
From: LANGLEY MCKELVY                                       Time: 12:19pm
\/To: JIM PURCELL                                         (Read 7 times)
Subj: mp2?

 On 07-31-95 JIM PURCELL wrote to LANGLEY MCKELVY... 
 
 JP> Let me know what your doing with MP2. 
 
 I am unfamiliar with mp2.  I'm not sure what you are referring 
 to, I think maybe that a message got crossed somehow.  If 
 you have questions about Paradox for DOS I can probably help. 
 
 Sorry,  
 
 Mac 
 
... OFFLINE 1.50 
--- Alexi/Mail 2.02b (#12)
(1:106/4196)
---------------