My company use 5 main documents. SalesInv, CreditorsInv, BankReceipt, BankPayment, Journals. I created a table for each, and formatted the Auto Number, my choice 3 letters and 6 numbers. I.e. INV000001, CDI000001, REC000001 etc. In a normal query it will show the document numbers correct. When I create a Union query it will only show the numbers, not the prefix in the format. Maybe when I create the queries to prepare for the Union query, there is a way? I accept autonumbers are not reliable.
How do I generate numbers in another field and by code generate the following number. If I do want to start with INV000001 and then INV000002 of course.