I desperately need some help. I would like to make a form that will allow the user to input a new invoice number, and has fields for user input that will allow them to input order numbers, once the user inputs a number it will pull up certain fields from the orders table so that the user knows which order it is. I need them to be able to input up to 30 different orders per invoice, and then the invoice number will be added to the records from the orders table they've input.
I know very little about macros or SQL, but I'm willing to learn. Any help you could possibly give me would be greatly appreciated.