Re: another Table another query coming soon

2003-03-10 Thread Roger Baklund
* 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

another Table another query coming soon

2003-03-07 Thread Andrew
Hi Guys and Dolls 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? Andrew

Re: another Table another query coming soon

2003-03-07 Thread Roger Baklund
* 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? Create a

RE: another Table another query coming soon

2003-03-07 Thread Andrew
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