Creating invoices, pulling info from Client table
I've created two tables, first one being my clients and all related information and the second table for my products.
What I would like is to be able to click a drop-down box, click the client name and have Name and address populate automatically. From there, the same for products.
If the process is any easier... Maybe a button in my client table that when pressed sends Name and Address to a new invoice.
If someone can point me in the right direction, I'd truly appreciate it. I'm sure I'll have more questions, but this will keep me busy for now.
Thanks a million,