Hello y'all! I'm looking for a bit of advice/inspiration for the next bit of my project.

Part of what my Db does is quotes. I have a main TblQuotes & TblQuoteItems. A quote will typically include products from two suppliers and own consultancy.

I have created TblOrders which includes the Pk (QuoteRef) but i really need advice about how to get access to generate the purchase orders to my suppliers. I would like the purchase orders to be reports as I will want to output to pdf or tif. the other thing is that each ordser generated also has to have a unique purchase order number.

Any advice much appriciated :rolleyes: