Advice needed in a little simple language, as I am a little novice.
I've created a DBase thats lists Jobs done on a daily basis for customers. I week after the job is completed I will receive a PONo. One PONo could be for several of the jobs.
I need to invoice the company seperate invoices grouped by Cp/PONo but still have the Inv no. recorded against each Job line. I haven't put in invoicing fields/tbls in the DBase yet I need guidance on design and set up of tables/relationship/query. A set by step guide would be good. I know how to do tables/querys/update querys etc.
I have seen several examples of invoice relationships but these are all one invoice number to one invoice line, I could do that.
HELP !
I've created a DBase thats lists Jobs done on a daily basis for customers. I week after the job is completed I will receive a PONo. One PONo could be for several of the jobs.
I need to invoice the company seperate invoices grouped by Cp/PONo but still have the Inv no. recorded against each Job line. I haven't put in invoicing fields/tbls in the DBase yet I need guidance on design and set up of tables/relationship/query. A set by step guide would be good. I know how to do tables/querys/update querys etc.
I have seen several examples of invoice relationships but these are all one invoice number to one invoice line, I could do that.
HELP !
Comment