Imeetsya dve tablizhi

1) Train_Shadule:
TGV_ID
From:int
To:int
Time_for_trip
Time_for_pause
Price

2)Stations:
Station_ID:int
Name

Svyazannie po unikalnomu kluchu Stations.Station_ID s TGV_Shadule.From i TGV_Shadule.To

Sozdau ADODataSet1+DataSource1+DBGrid1

ADODataSet1.SQL:='
select [R].TGV_ID, [S].[Name], [S1].[Name],[R].Time_for_trip,[R].Time_for_pause,[R].Price
from [Train_Shadule] as [R]
join [Station] as [S] on [R].[From] = [S].[Station_ID]
join [Station] as [S1] on [R].[To] = [S1].[Station_ID]

V itoge poluchau krasivuu tablichku s nazvaniem stanzhiy v polyah To i From (vmesto id nomera stancii)

No problema teper v tom kak takuu tablizu redaktirovat?
Ya nashel reshenie podobnoy problemi na


No tam primer dlya Access2000
A umenya SQL2000 i on rugayetsy tipa 'Unique Table nesushestvuet ili nepolnostu opredelen'
hoty ya propisal strochki tipa
ADODataSet1.Properties['Unique Table'].Value:='Train_Shadule';

Kto moget pomogite!
Zaranee blagodaren

Ya tak tozhe mogu cherez DBLookupComboBox
No mne nado chtobi on vidoval v DBGrid v vide nazvaniya stanzii a ne Station_ID

Pomoemu uzh proshe izmenit tip From i To na Char i vnosit nazvaniee napryamuu pez svyazki. Pravda eto bezgramatno s tochki zreniya postroeniya DB zato vse budet rabotat bez gimaroya :)

Mda klevaya shtuka no ya hotel chtoto tipa

http://www.delphikingdom.com/helloworld/ado03.htm