* Andrew
> Actually thinking about this in a bit more depth! I also have
> the infamous
> items table where individual company records are being stored.
> So is the best way to do this:
>
> i) add another field that will coreespond to the items.ItemsID or
I don't know what you mean.
> ii) create
ch will then involve adding another column to the items table :(
Andrew
>-Original Message-
>From: Roger Baklund [mailto:[EMAIL PROTECTED]
>Sent: 07 March 2003 14:51
>To: MySQL-Lista
>Cc: [EMAIL PROTECTED]
>Subject: Re: another Table another query coming soon
>
>
* Andrew
> I am going to add another table to my lovely MySQL DB.
>
> Basically it is the city table I need to add to. For each city I
> am going to
> have Towns. So I need to relate many Towns to one CityID
>
> The city table at the moment is:
>
> City CityID
>
> What the best way forward?
