How do I generate a picklist for a field so that the list contains information from different fields?
I have a small application that has a handful of forms (ie., person, person address, person phone). I created the tables in Microsoft Access and imported the tables into Zoho Creator using the migration tool. The person form contains the fields: person_id, last_name, first_name, and middle_init. The person_id field has logic so that the field is auto-generated. On the person_address and person_phone forms they contain a field called person_id. The person_id on the address and phone forms are foreign keys to the person_id on the person form.
With that being said, the person_id field on the person_address form is a pick list that shows the person id's saved in the person form. The problem is, that I can't identify someone by a number unless I look them up in the view to see what the name is associated with the number. I would like for the picklist to show the person_id, last_name, and first_name when I choose the list to add a person's address, for example. Now I see: 1 I would like to see: 1 Smith, Joseph
Can anyone tell me what code to put that would allow the picklist to show my person_id with the associated name information so that I can choose the person I want from the list without having to know what their number ID is?
Thanks
Kevin