How do I bring the price from my product/service form to another form linked by a look up field?
Hi, I am trying to figure out how to get the price from the parent form into the child form. I am kind of new to this and haven't been able to figure it out. Any help would be appreciated.
Parent Form
Form Link Name: Add_Product_Service
Fields: Product_Service_Name, Price
Child Form
Form Link Field: Kit_Sub_Form
Fields: Product_Service (Linked by lookup field from parent form), Price (NEEDED FIELD FROM PARENT FORM)
Note: The Product_Service and the Price of the child form will be used by a subform in another form.
Thanks,
Craig