Firstly you need to index home_location_id in the customer table, then it should work.
On 14/7/03 4:06 AM, "David Corsaut" <[EMAIL PROTECTED]> wrote: > trying to add a FK to an existing table, to see table > structures, alter table syntax and error refer to > http://sourcepost.sytes.net/sourceview.aspx?source_id=6332 > > ===== > David L. Corsaut > [EMAIL PROTECTED] > mobile: 206.790.0969 > > __________________________________ > Do you Yahoo!? > SBC Yahoo! DSL - Now only $29.95 per month! > http://sbc.yahoo.com Ryan Henderson Computer Programmer Multimedia Centre, Faculty of Arts, University of Western Australia + 61 8 9380 2891 Imagination is more important than knowledge... knowledge is limited, but imagination encircles the world. Albert Einstein -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
