Hey all,
I have 4 tables:
Quote: QuoteID / Date / Accepted
QuoteDetails: QuoteDetailsID / QuoteID / Job / Qty / Price
Invoice: InvoiceID / QuoteID / JobInvoiceNumber / Date
InvoiceDetails: InvoiceDetailsID / InvoiceID / QuoteDetailsID / Progress
I would like to do is:
IF JobInvoiceNumber = 1 then copy / paste all QuoteDetailsID where QuoteDetails[QuoteID]=Invoice[QuoteID] to InvoiceDetails[QuoteDetailsID]
So far i have set up a bot to do this, but i get stuck in the Process tab. I have gone for Run data action / Add new rows
And, for the InvoiceDetails[QuoteDetailsID], i put: SELECT(DetailDEVIS[DetailDevisID],[DevisID]=[_THISROW].[DevisID]) which is a list...
Any thoughts?
Thanks.
Matt
LinkedIn
Twitter
