Tuesday, June 29, 2010

GoldMine: More Data in One Field

A user asked: I need to have more than one entry from a Lookup List in a data field. How do I do this?

Normally, when you select a choice from a Lookup List, your choice overwrites whatever was already in the data field. The semicolon allows you to add your selection to the already existing data without removing the original data.

* Pull up the Lookup List you want to modify
* Choose the field entry to modify > click Edit.
* After the data in the Enter the F2 Value box,
* Add a semicolon (;). Click OK to save.

That choice in your lookup will now go into the data field immediately after the data that is already there, separated by a comma and a space. Using this technique, you can have multiple selections in your data fields.

Note: When adding multiple selections, be aware that you can sometimes run out of space in the data field. Comma and spaces count toward field length along with the actual number of characters.

Also, using semicolons will not work if you are using the Force Valid Input option in the F2 Field Setup box. If you want to use semicolons, pull up the Lookup List you want to use them with and go to Setup; then uncheck the Force Valid Input box and hit OK.

1 comment:

aliya seen said...

I wanted to thank you for this excellent read!! I definitely loved every little bit of it.Cheers for the info!!!! secondary analysis of data