ALTER TABLE TO SET RELATIONSHIP 1

[hbez]

I have two existing but currently unrelated tables. I have tried
ALTER TABLE tblFlights (Airplane TEXT(20) REFERENCES tblAircraft(Airplane));
and variations on this theme, but I keep getting a syntax error. Airplane is the key field in the table tblAircraft and I want to set up a 1-many relationship to the Airplane field in the table tblFlights.
Using the line in a CREATE TABLE statement works fine.
My SQL knowledge is somewhat sketchy so I would really appreciate help with this one.

Hannes

 

[towerbase]

Which DBMS are you using?

You might try posting in the appropriate forum for the DBMS as this doesn't seem to be a Delphi issue.

Andrew
Hampshire, UK