I have a Grandparent-Parent-Child table question. My Grandparent table is ORDERS, Parent is PRODUCTS, and child is INVENTORY ADJUSTMENTS. From the ORDERS table, I am first directed to the PRODUCTS table to create a new product record. From there I click on a URL Button that directs me to INVENTORY ADJUSTMENTS where I enter quantity and pricing. Once I save from INVENTORY ADJUSTMENTS I am redirected back to the PRODUCTS table. This makes sense to me. But now I'd like to add two additional options on the PRODUCTS table in the form of URL Buttons. One "SAVE AND ADD NEW PRODUCT" and the other "SAVE AND RETURN TO ORDER." I currently have a "SAVE AND ADD NEW PRODUCT" button using this formula
But it doesn't link the new product record to the original grandparent table. How do I modify this so that it does? This would increase efficiency for entering multiple new products.
I would also like the option to save the product record and return to the Grandparent table, ORDERS. How would I write the formula for that?