AnsweredAssumed Answered

Tool Tip calculation

Question asked by thong127 on Jul 15, 2009
Latest reply on Jul 16, 2009 by philmodjunk

Title

Tool Tip calculation

Post

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.

Outcomes