Work DBase – I have created all customer and job tables and everything works well.
However, every couple of weeks I will get a Purchase Order Number and need to invoice the jobs, some jobs are on single PO No.s/invoices, some jobs are all grouped on one PO No.s/invoice. I can’t for the life of me think how to plan/design this, an append query ? group query ?.
Any guidance would be REALLY helpful, as I’ve got to get this done by Monday !!
Thanks
