Nested lookup for data entry
I need to implement a lookup value to include an item in a form. However, I need to use a sort of nested lookup. This involves two one-to-many relationships. I give an example below.
I have a table called Car. I want to characterize that car by its attributes or fields in a table or form as we say in zoho.
On the Car form, I need a means to choose a make, then a Model within that Make. I need to retain the information within the form that will allow me to later reference both the make and model either through some sort of key or ID.
One thought would be to execute some sort of form script on "field action" "on user input" for the Make that would populate a dropdown in order to select the Model.
It could look something like the selection list we see when choosing where to get lookup info from when adding a lookup field to a form. First we choose an application, then that populates the Form list so the user may choose a form for the lookup.
Regards,
David
Writer
Get Started. Write Away!
I have a table called Car. I want to characterize that car by its attributes or fields in a table or form as we say in zoho.
On the Car form, I need a means to choose a make, then a Model within that Make. I need to retain the information within the form that will allow me to later reference both the make and model either through some sort of key or ID.
One thought would be to execute some sort of form script on "field action" "on user input" for the Make that would populate a dropdown in order to select the Model.
It could look something like the selection list we see when choosing where to get lookup info from when adding a lookup field to a form. First we choose an application, then that populates the Form list so the user may choose a form for the lookup.
Regards,
David
Access your files securely from anywhere
Zoho Developer Community
New to Zoho LandingPage?
Zoho LandingPage Resources
New to Zoho Survey?
New to Zoho CRM Plus?
Deliver unforgettable customer experiences
New to Zoho CRM Plus?
Deliver unforgettable customer experiences
New to Zoho Marketing Plus?
Everything you need to run your marketing
New to Zoho Marketing Plus?
Everything you need to run your marketing
New to Bigin?
Topic Participants
dejswa
Anup PS
MAHESH B KUNCHALA
New to Zoho TeamInbox?
Zoho TeamInbox Resources
Zoho DataPrep Resources
Zoho CRM Plus Resources
Zoho Books Resources
Zoho Subscriptions Resources
Zoho Projects Resources
Zoho Sprints Resources
Qntrl Resources
Zoho Creator Resources
Zoho Campaigns Resources
Zoho CRM Resources
Design. Discuss. Deliver.
Zoho Show Resources
Get Started. Write Away!
Writer is a powerful online word processor, designed for collaborative work.
Zoho CRM コンテンツ
-
オンラインヘルプ
-
Webセミナー
-
機能活用動画
-
よくある質問
-
Ebook
-
-
Zoho Campaigns
- Zoho サービスのWebセミナー