mkohler28 Posted April 15, 2008 Share Posted April 15, 2008 I have a text field that is a lookup field and finds instructions from a related table, I am trying to set up the field so that a user can add or ammend text to the field without the ability to erase the original instrctions that was looked up. How would you set this up or would you as an auto-calc? Link to comment Share on other sites More sharing options...
Maarten Witberg Posted April 15, 2008 Share Posted April 15, 2008 Hi, try Case ( not PatternCount ( TheField ; Lookup ( TheLookupTable::TheLookupfield ) ) ; Lookup ( TheLookupTable::TheLookupfield ) & " " & TheField ; TheField ) as auto-enter replaces existing. Link to comment Share on other sites More sharing options...
Maarten Witberg Posted April 15, 2008 Share Posted April 15, 2008 a gotcha... i just realised that this will in fact replace the looked-up contents with the most recent content of the lookup field which may not be what you want. perhaps a solution is needed where you have a secondary field that is used to store the original looked up value and use that in the above calc instead of the lookup() function. but I am starting to wonder what you are wanting to achieve. Link to comment Share on other sites More sharing options...
mkohler28 Posted April 16, 2008 Author Share Posted April 16, 2008 My goal is the lookup text cannot be removed as they are reuired specific instructions but extra text can be added. if a user deletes the lookup text and enters something else I want the field to revert back to the Lookup Text - New Text Link to comment Share on other sites More sharing options...
Maarten Witberg Posted April 16, 2008 Share Posted April 16, 2008 ok so if I understand correctly you can use my original solution. Link to comment Share on other sites More sharing options...
By Soliant Consulting,
By Soliant Consulting,
By Soliant Consulting,
Recommended Posts