When adding / editing data in a browser window from an ODBC linked table it would be nice if the browser honoured the SQL foreign keys and constrains at the point of entry.
i.e only allowing you to enter valid data rather than allowing you to enter anything and then failing when you try to commit the changes to the database.
It would be awesome if a field with a foreign key displayed a picklist ( from the foreign key ) at the point of data entry.



