It sounds like we want to take the values from one table and make them into a drop down in another, related table. If this is the case, this is done through the creation of the relationship field. This will present as a drop down field in the child table that allows you to determine to which parent record to relate the child record.
Regards,
Alex
0
Permanently deleted user
Esrana Sikdercommented · ·
I tried this already but it shows the record ID in the dropdown list..how can I specify which field I want to show in the dropdown list? And thanks for the response
0
Permanently deleted user
Alexcommented · ·
Hi Esrana,
The drop-down is the record ID from the parent table. This record ID can be changed in the table setup of the parent table. The record ID for any table can be a combination of any field in the table, there is additional information in our Knowledge Base Article below:
Comments
4 comments
Hi Esrana,
It sounds like we want to take the values from one table and make them into a drop down in another, related table. If this is the case, this is done through the creation of the relationship field. This will present as a drop down field in the child table that allows you to determine to which parent record to relate the child record.
Regards,
Alex
I tried this already but it shows the record ID in the dropdown list..how can I specify which field I want to show in the dropdown list?
And thanks for the response
Hi Esrana,
The drop-down is the record ID from the parent table. This record ID can be changed in the table setup of the parent table. The record ID for any table can be a combination of any field in the table, there is additional information in our Knowledge Base Article below:
http://help.trackvia.com/knowledgebase/articles/273364-how-to-create-a-unique-id
Regards,
Alex
Thanks, got this right
Please sign in to leave a comment.