How to save the field value and not the ID

Scriptcase 9 General
#1

Have two tables.
Table 1 = Animals
Table 2 = breed

When filling in the form for table 2, I use a selection field for animals. But now in table 2 under the field animals the ID from table 1 and not the animal name is stored.
How can I save the name for the animal (instead of the ID) in table 2?

#2

select field will save whatever you set as the first field in the automatic selection setting of the field.
so you should do : select animal_name from table1 instead of using animal_id

#3

Great… now the data is stored the way I want :wink:
Thank you.