I'm very happy working with PHP/MySQL and editing my databases with PHPmyAdmin.
However, one annoyance I wonder about is whether I can somehow use "drop-downs" and "lookups" such as we are accustomed to seeing in MS Access (Windows) or Filemaker Pro.
Right now, I'm referring to records in other tables simply by inserting the relevant ID number, which is all well and good, but it would be nice to be able to populate a picklist or dropdown menu with th results of a MySQL query, wouldn't it? That way, if I were to enter a record for
Mona Lisa, I could select the artist "Leonardo Da Vinci" from a picklist instead of having to look up the ID number (e.g., 387) and hand-key that into my artist_id field.
EDIT:
This article appears to identify this as a matter of enabling the relational features of PHPmyAdmin. I wonder if I can talk my ISP into doing that....
Would love to hear comments from the peanut gallery....
Top
