This is probably pretty easy, but I can't get my head around it because it involves pulling data from a joined MySQL Select statement, and its causing problems. It is a basic Add/Edit/Delete system in PHP/MySQL. I have a table called 'ARENAS'. The table consistes of 2 fields. One is an auto-incrementing ID field, and the other is a text field. The main table is called 'RENTALS' and it contains 5 fields. An auto-inc. ID field, DATE field, START (time) field, END time field, and an RINK (foreign key; ARENAS.ID) field. When I go to edit an entry from the 'RENTALS' table, the values for ID, DATE, START, and END will carry over and display properly with no problem, however, the RINK field will pull the top value from the 'ARENAS' table, not the actual value in the row. Now, if I have it set to display just the ARENA.ID, it is fine, but, I would like to see the actual arena name, not the numerical value (which would be ARENAS.ID). I am currently using a drop dowm menu to display this information. All of the other fields, that are just text boxes, not drop-down menus, display perfectly fine. Any help would be appreciated.