Hi,

I have a problem where by my customer require their staff to key in "WHY U SEARCH FOR THIS RECORDS". So I created 2 tables. 1 is the main page which contains the info and the table 2 is the query page.

So after I press the submit button it will copy what I keyed in the query page and perform find at the main page.

I only can get 1 field but when I copy all the field which I need, it's not working. The file in the query page can be randomly filled base on name only or combination of name and products. Then upon clicking submit it will copy this 2 field which I have fill in something and perform find in the main page base on that.

Attached is what I have did. Can anyone help me ?

queryreason.zip

Your idea is good.

I changed your attachment for working.

Other way is to create relation between this tables then use fields of query in main page.And there is many other ways to do it.

queryreason.zip

Thanks a lot again for helping me .It works.

P.S. The earlier problem which u suggest me is not what I want. The thread is

http://www.fmforums.com/threads/showflat.php?Cat=0&Number=161979&an=0&page=0#161979

What do the "XXX" means and the ;4;1?

Case (MiddleWords ( Get ( ScriptParameter );4;1 ) = "XXX";"";MiddleWords ( Get ( ScriptParameter );4;1 ))

See button Sibmite sends parameter:

Case ( IsEmpty ( query reason::name );"XXX";query reason::name) & " " &

Case ( IsEmpty ( query reason::address );"XXX";query reason::address)& " " &

Case ( IsEmpty ( query reason::product );"XXX";query reason::product)& " " &

Case ( IsEmpty ( query reason::price );"XXX";query reason::price)

If the word which I look for is in single word, then it is fine. For example the first customer name is ALBERT HO. Then your method can't find it. Customer name usually will be variable.

Case # 1 = ALBERT. [Your Solution Works]

Case # 2 = ALBERT HO [Not Working]

Case # 3 = ALBERT K K HO [ Not Working ]

Thanks for your time on helping me.

Customer name in my solution must be only one word. If you want that this will be few words you must change script. I will try to change it.

This is other way to do it - by relation.

See attachment.

queryreason2.zip

Thanks a lot. Really appreciate it.