Hellmut Posted May 17, 2006 Share Posted May 17, 2006 I want to link a numeric and a text field such that a specific numeric value will trigger the display of a word. Both fields are in the same table. For example, in the table nobility anyone who is a one is a knight. Anyone who is a two is a baronet. Anyone who is a 3 is a baron etc. Link to comment Share on other sites More sharing options...
MarkWilson Posted May 17, 2006 Share Posted May 17, 2006 (edited) A couple of options. 1) If the range of numbers is known, limited, and has a sequence. TextField = Choose( NumberField ; "" ; "Knight" ; "Baronet" ; "Baron" ... ) * Choose() is a zero based index with 1000 repetions. 2) If the range of number is known and limited. TextField = Case( NumberField = 1 ; "Knight" ; NumberField = 3 ; "Baron" ; "Default Text" ) 3) Create a new table with all the combinations (or ranges of combinations) and use a Lookup. * This may be be your best option for an expandable solution. Edited May 17, 2006 by Guest Link to comment Share on other sites More sharing options...
Hellmut Posted May 17, 2006 Author Share Posted May 17, 2006 Thanks, Mark. Do I create all the combinations as records? Link to comment Share on other sites More sharing options...
MarkWilson Posted May 17, 2006 Share Posted May 17, 2006 Here is a sample. Feudal.zip Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 6552 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now