basically everything is held in items, only for each city the I want the city id to be dispayed for the category in city. I am not sure what you need to know? Should there be a relationship between city and category? I cant see why there should. Andrew >