Subform records from one form to another
I have a form “Add Item” (Screenshot attached).
I have another form “Purchase Order” which has a subform “Item Details”.
“Item code” is a lookup field of “Add Item” form’s “Product code” field
We need that when the product code is selected, the code should add the records of “Diamond details” subform from “Add Items” form to “Purchase Order” form.
For each item added in the “Purchase Order” form, there should be a new table added to “Purchase Order” with “Diamond details” records from “Add Items” form.
Also when the”diamond details” subform records are added to the “purchase order” form, the code should add 2 more fields “price per carat” and “total”.
I have attached the “Add Item” form’s fields in a separate PDF.
Please let me know how to achieve this.
Topic Participants
lakhanimohit
Vigneshwaran K
Zoho CRM Plus Resources
Zoho Books Resources
Zoho Subscriptions Resources
Zoho Projects Resources
Zoho Sprints Resources
Zoho Orchestly Resources
Zoho Creator Resources
Zoho WorkDrive Resources
Zoho Campaigns Resources
Zoho CRM Resources
Get Started. Write Away!
Writer is a powerful online word processor, designed for collaborative work.
-
オンラインヘルプ
-
Webセミナー
-
機能活用動画
-
よくある質問
-
Ebook
-
-
Zoho Campaigns
- Zoho サービスのWebセミナー