1 Reply Latest reply on Jul 16, 2009 10:55 AM by philmodjunk

    Tool Tip calculation



      Tool Tip calculation


      Hello to everybody,


      Kindly help me  with my calculation to my tooltip to populate my other fields


      I have a table name "Invoice" which contains the following fields


      1. Vendor

      2. Address

      3. Tel No.

      4. Fax No.


      and I have also a table "Vendors" which contains the following field


      1. Vendor Name

      2. Vendor Address

      3. Vendor Phone No.

      4. Vendor Fax No.


      Now, in the "Invoice" table I made a button with a tool tip calculation If (Invoice::Vendor =Vendors::Vendor Name = "Yes" ; "Click here to copy Vendors::Vendor Address to Vendors::Vendor Fax No.."; "") Can you help me with this calculation please.


      I have also a the following script for the button


      1. Set Field [Invoice::Address; Vendors::Vendor Address]

      2. Set Field [Invoice::Tel No.; Vendors::Vendor Phone No.]

      3. Set Field [Invoice::Fax No.; Vendors::Vendor Fax No.]

      4. Commit Records/Requests [Skip data entry validation; No dialog]



      Thank you very much.

        • 1. Re: Tool Tip calculation

          You have a problem with this part of the expression:

          Invoice::Vendor =Vendors::Vendor Name = "Yes"


          This makes no sense.


          If you want test to see if the two fields to contain the same data use Invoice::Vendor =Vendors::Vendor Name


          If you want to test to see if both fields contain "yes" use Invoice::Vendor = "Yes" AND Vendors::Vendor Name = "Yes"