Jump to content

Linking Two Fields


Hellmut
 Share

This topic is 5684 days old. Please don't post here. Open a new topic instead.

Recommended Posts

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

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 by Guest
Link to comment
Share on other sites

This topic is 5684 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 account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.