I essentially created an account since I can't seem to find a straightforward answer much anywhere else (plenty of hints on auto-filling forms- but that isn't particularly conducive to my specific need on this).
I've attached a blank copy of my database.
I may need some help overall- but the immediate concern I'm having is that I want to be able to autofill data in the invoice table based on the customer table and the products/service table.
*I want to be able to select a first name [or other primary key if necessary] to fill in the last name, company, address, city/state/zip, phone, fax, cell/alt phone, and email automatically... that is without multiple dropdown selections or input to those sections at all.
*I want prices to fill in to the 'cost of product/service X' so that I may use it for other calculations in the invoice table- as well as to make forms from it directly.
I haven't had the most luck with getting an answer- let alone any assistance, and am hoping that I'll have more luck here. It's proving to be a much larger undertaking than expected to do these relatively small tasks for me, and I just want to move on to getting it up and running.
I've attached a blank copy of my database.
I may need some help overall- but the immediate concern I'm having is that I want to be able to autofill data in the invoice table based on the customer table and the products/service table.
*I want to be able to select a first name [or other primary key if necessary] to fill in the last name, company, address, city/state/zip, phone, fax, cell/alt phone, and email automatically... that is without multiple dropdown selections or input to those sections at all.
*I want prices to fill in to the 'cost of product/service X' so that I may use it for other calculations in the invoice table- as well as to make forms from it directly.
I haven't had the most luck with getting an answer- let alone any assistance, and am hoping that I'll have more luck here. It's proving to be a much larger undertaking than expected to do these relatively small tasks for me, and I just want to move on to getting it up and running.