Good Day to All,
I am very new Access. Sorry my English was not good. I Have two Parent table with child table, for Quotation and Invoicing, as shown below.
Once our quote is approved we need to convert the quote for certain line items as invoice. For this I need to select some line items in quotation sub-form and pass the same to invoice form by a button click.
how to copy the selected item in quotation line form to Invoice line form.
Can anyone help me to prove the code for this button click.
Tables:
Quotation(Table) - Parent
Quote Number(Primary)
Quote Date
Customer Name
Quotation Line(Table) - Child
QuoteNumber
S.No
Description
QTY
Unite Price
Select
Invoice(Table) - Parent
Invoice Number(Primary)
Invoice Date
Customer Name
Invoice Line(Table) - Child
Invoice Number
S.No
Description
QTY
Unite Price
I am very new Access. Sorry my English was not good. I Have two Parent table with child table, for Quotation and Invoicing, as shown below.
Once our quote is approved we need to convert the quote for certain line items as invoice. For this I need to select some line items in quotation sub-form and pass the same to invoice form by a button click.
how to copy the selected item in quotation line form to Invoice line form.
Can anyone help me to prove the code for this button click.
Tables:
Quotation(Table) - Parent
Quote Number(Primary)
Quote Date
Customer Name
Quotation Line(Table) - Child
QuoteNumber
S.No
Description
QTY
Unite Price
Select
Invoice(Table) - Parent
Invoice Number(Primary)
Invoice Date
Customer Name
Invoice Line(Table) - Child
Invoice Number
S.No
Description
QTY
Unite Price