We help IT Professionals succeed at work.

Check out our new AWS podcast with Certified Expert, Phil Phillips! Listen to "How to Execute a Seamless AWS Migration" on EE or on your favorite podcast platform. Listen Now

x

FM - What Method to Use When Field is Both Looking Up Data and Needs Data Entry

rvfowler2
rvfowler2 asked
on
Medium Priority
616 Views
Last Modified: 2012-08-14
I have the following scenario and wondering if the only solution is two separate fields.  I need a field where it sometimes needs to copy the commission amount from another table/field and sometimes I need to enter it manually.  I thought of a lookup or auto-calc; however, the I need to create the Closing Notes record at the same time I create the listing record and thus the commission to be oopied is empty at the time of record creation.  I can solve this by using a script trigger to relookup at the time I need to enter the closing notes for a sold property; however, this relookups all records and will overwrite any manual entries with the blank field over in the other table.  

Question:  Is there a way that I can force a lookup on only one record?  Or, am I stuck with creating one calc field and one manual entry field?
Comment
Watch Question

Author

Commented:
Of course, there is always a script step of If not IsEmpty, copy the contents over.
Will LovingPresident, Dedication Technologies, Inc.
CERTIFIED EXPERT
Commented:
Unlock this solution with a free trial preview.
(No credit card required)
Get Preview

Author

Commented:
Thanks, definitely overthought that one.  And in a related issue, there is no way to force the auto-calculate to recalculate like you can with relookup, correct?
President, Dedication Technologies, Inc.
CERTIFIED EXPERT
Commented:
Unlock this solution with a free trial preview.
(No credit card required)
Get Preview

Author

Commented:
Thanks, I did use your tip about autocalc to correct phone numbers and both cleaned up my database and have auto-calced it to auto format any phone numbers entered in the future.  And thanks for the db merge article; just merged my 4th set of databases.
Unlock the solution to this question.
Thanks for using Experts Exchange.

Please provide your email to receive a free trial preview!

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.