Creating an Invoice with Manual Input of Order Info

DarylinJ  this is no issue...there are plenty ways to do it...but keep in mind that the "manual" way is always the best recipe for errors...

Lets take an example :

Assume you are Amazon - alike company and you are selling books

And a customer (A) comes and asks a copy of Book named "Programming in Access by Someone"...you have it in your stock ..so you enter "Programming in Access by Someone" ...and you sell it.

Then a 2nd customer comes (B) and ask for the same book "Programming in Access by Someone"...mistakenly you type "Advanced Programming in Access by Someone"...probably it would have in the cover somewhere the word "Advanced"...no big deal..you have a 2nd copy in your stock and you sell...

But sometime later you need to have a stocktaking...and you cross reference with your invoices...the book is called "Programming in Access by Someone" but while you should  had 2 in your stock ...you only see 1...oops no there is an issue....where did the other copy went.....if you are small business and you scroll all your invoices you should probably pick it up by "visual examination"....but computers are dumb (that's why AI is the big fuss in the market right now) ...so whatever you do that relies on giving that exact parameter(queries/reports/forms) ...it would only show this 1 entry...the other is pretty much gone.....

Instead if...you had assigned some particular code to this book e.g. 1234 ...in every case some customer would come and ask to buy this particular book it will point to this specific code (1234) that in turn points to the exact book....no mistakes...what do you think ?

JT