Correct way of databinding of foreign key?
Database
1
Posts
1
Posters
0
Views
1
Watching
-
This thing bother me some time already Say I have form that should display data about some student; one of thing it need to display is cityID which is just foreign key to some city in table city. How can I make it display name of city instead of ID, but write ID to table student. I tried to do this logical way but never worked, first if there is some data in base it'll show FK value instead on city name, second when I drop down list I get names of cities, but when I pick one from list I never can continue even though I selected value member as ID field not name field (in parent table). I tried any combination available still doesn't work as expected. all data is show in details mode and combo box is for cityID value... Any idea?