How do I use the SHOW CUSTOM DIALOG function to populate a query of six fields in one database?

[NEMC]

Hi, I'm new to FM7, but I've used other database applications in the past .
. . . .

How do I use the SHOW CUSTOM DIALOG function to grab user input and then use
that to populate a query of six fields in one database?

I want to search for whatever the user enters, ie the name "John", and then
search the NAME, ADDRESS, ACCOUNT NUMBER, NICKNAME, etc . . . . fields.

Thanks!

Nathan

[G.Miller]

Post by NEMC
How do I use the SHOW CUSTOM DIALOG function to grab user input and then use
that to populate a query of six fields in one database?
I want to search for whatever the user enters, ie the name "John", and then
search the NAME, ADDRESS, ACCOUNT NUMBER, NICKNAME, etc . . . . fields.
Thanks!
Nathan

Create a global field called Global_Find to use in the custom dialog for
input. Then use multiple find requests. Make sure you add the requests
separately, then do a 'perform find' to run them all at once.

Then in your script, do this:

Enter find mode
Set Field (Field1; Global_Find)
New Record/Request
Set Field (Field2; Global_Find)
New Record/Request
Set Field (Field3; Global_Find)
Perform Find



geoff

[AL Lawrance]

You can also invest in a 24UDialog plugin at http://www.24usoftware.com/

You can input all 6 fields in the single dialog and they can be edit box,
check box, menu list and a calculated field. It is superior to the built in
FM Pro 7 custom dialog which is limited to 3 fields with no ability to have
them menu lists, check boxes etc.
--
Lawrance Database Designs
A J Lawrance
British Columbia, Canada
URL: http://www.members.shaw.ca/ajlawrance/index.html

Post by NEMC
Hi, I'm new to FM7, but I've used other database applications in the past .
. . . .
How do I use the SHOW CUSTOM DIALOG function to grab user input and then use
that to populate a query of six fields in one database?
I want to search for whatever the user enters, ie the name "John", and then
search the NAME, ADDRESS, ACCOUNT NUMBER, NICKNAME, etc . . . . fields.
Thanks!
Nathan