Discussions

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

  • 1.  Create new Parent and Copy Child record from an Existing Child Record

    Posted 03-08-2018 20:00
    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!