I have a database with a foreign key relationship like this:
Parent table :
- town_id (integer)
- town_name (text)
Child table:
- address_id (integer)
- town (integer) (=related to town_id)
The releationship between town and town_id works fine if I edit the data in the database via phpMyAdmin.
In the example video of Phreeze, I see a dropdown with text (in my case: town_name) for selecting a foreignkey in the child (in my case: town_id).
But when I generate the application, when adding a new record in the child table, All I can select is the town_id in the child table - town field.
I have a database with a foreign key relationship like this:
Parent table :
Child table:
The releationship between town and town_id works fine if I edit the data in the database via phpMyAdmin.
In the example video of Phreeze, I see a dropdown with text (in my case: town_name) for selecting a foreignkey in the child (in my case: town_id).
But when I generate the application, when adding a new record in the child table, All I can select is the town_id in the child table - town field.