Duplicate form content from two tables

[jotaen]

I have a form (parent form) where I make quotes for clients. The table for that form as multiple columns as follow:
(Table name: "quotes for client")

• ID
• Client_ID (related to the main table where I keep client details)
• Quote_Date
• Payment_Terms
• Task_Conclusion_Date
• Notes

Than I have a subform where I gather some details of the quote, like:
(Table name: "quotes details")

• ID
• Quote_ID (related to the table "quotes for client")
• Product_Description
• Product_Index
• Product_Price

How can I duplicate the fields from that two table into a new quote (containing all fields from the two forms)?

 

[pbaldy]

How about:

http://allenbrowne.com/ser-57.html

 

[theDBguy]

Hi jotaen. Welcome to the forum. Let us know if you have any questions after looking at the link Paul posted.