select_single / results page problems

[whity]

imagine you've got two tables:

cities(id, cid, name)
countries(id, name)

where cid is the id of the country the city belongs to.

now you modify the interface for the cities table by changing the cid's field type to select single. the primary key is "id", the linked field "name".
save and look to some search results: the cities' names in the table are overwritten by the names of the countries.

is there any possibility to solve this?

 

[Ueli Preisig]

If you look at your DB with phpmyadmin, you probably see that the values are inserted/updated correctly. The problem is, that you use 'name' twice. Change your tables to

cities(id, cid, city_name)
countries (id, country_name)

for example. Adjust the attribute names in dadabix accordingly and you shold be fine.

 

[whity]

The problem is that i have got about 50 tables and a fairly large amount of existing code. I think it's less effort to write my own admin tool than to do that

But thank you!