Create new Parent and Copy Child record from an Existing Child Record

  • 0
  • 1
  • Question
  • Updated 1 year ago
  • (Edited)
I have two tables that are working together.

Table 1 = Parts Requests (Parent)
Table 2 = Parts (Child)

The Parts Requests table is used in 2 ways. 1. When a customer calls and asks for a quote for parts and 2. When we request a quote for a part from a vendor. 

The functionality I am looking for is this. If I have a Part Request from a customer (Scenario 1) that has a/some parts on it, I would like each of those child records to have a button to generate a new request. The new request will be scenario 2 above where we are requesting a quote for that part from a Vendor. 

Ideally, this button would generate a new Part Request checked off as a Vendor Request, and then it would also create a child record that is identical to the one I clicked the button on. 

This way when the request for a quote from a vendor is created, they don't have to enter the part information again. 

Any thoughts on how I can set up this button would be greatly appreciated!
Photo of Andreonna

Andreonna

  • 1,040 Points 1k badge 2x thumb

Posted 1 year ago

  • 0
  • 1

Be the first to post a reply!