I have just discovered through luck that I need to have the same record in (table items) accessable if it is listed as being in more than one city (table city). Obviously I don't want to create new records for the same item so it can be displayed if it's in different cities. Is the best way to do this to create a new table and call it reference_city with items.ItemID and city.CityID as the columns?
Yes, although I'd probably call it item_city to make it more obvious what it is.
Bruce Feist
PS If you specify sql,query,queries, or smallint in a message to this mailing list, it doesn't get nuked as spam!
--------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
