Skip to Content
author's profile photo Former Member
Former Member

Formatted earch Help

Good Evening

Experts:

Shopping for a bit of help with a Formatted search dilemna. I have a screen with Order# and Line#. After entering an Order# and Line# I then tab out of the Line#

field. If the Order# is valid then I check to make sure the Line# is valid for that Order#. If the Line# is not valid, I want to display a formatted search in the Line# field for all of the lines valid for the Order.

However, I cannot figure out how to reference the Order# field from the Formatted search that is displayed in the Line# field.

How can I do this?

Thanks,

Ed

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Sep 10, 2007 at 12:51 PM

    On a system form, say the order entry form, if I want to access the order# (docnum) of the order currently on the form in a formatted search I would

    write "select $[ordr.docnum] from...."

    I don't know if this will work if you have your own form or have a UDT but you could try "select $[@yourtablename.yourfieldname] and see what happens.

    BTW - neither of these will work via the execute button while writing the FS. You'll have to assign the fs to the field and run it like the user would to test.

    Hopefully this is what you are asking about.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Sep 11, 2007 at 01:51 PM

    Thanks...not exactly what I am doing but your response pointed me in the direction I needed to go to solve the problem.

    Thanks,

    Ed

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.