Okay, I'm putting together my first MySQL database, and this is should be really easy, but I am stuck on this one thing:
I have a table "customers", which has fields for name, address, tel#, etc.
I have another table "invoices", where I would like to be able to reference the data from the customers, in such a way that once their name is selected from a dropdown, the fields for address and such fill in automatically (because they are pulling from the same record in the "customers" table)
Seems easy? I've been messing with primary keys, foreign keys and the rest and can't get it to work. tables are InnoDB. I'm using PHPbuilder to create the web access pages.