Bear,
the reason I think the zip needs to be placed in it's own table is because this is a web app and it's going to be collecting several different kinds of data from users, each of which will be "identified" by it's zipcode
heck, here's more info than you want to know
I keep
bees the app is going to collect info about when flowers bloom, when pollen starts to flow, when drones are first raised, etc
each of these events is tied to the location where it happens by zip code
I'm also going out to "wunderground.com" and collecting LOT'S of weather data about each zip code
the idea is to collate all these events to the weather in the year they occur and then try to predict when things are going to happen this year (
beekeeping is all about "timing")
so, since several pieces of data are tied to the zipcode I think it deserves it's own table
Virag
the error I get is 1064 which appears to have something to do with ? being a reserved keyword
I think I'm just using it improperly
I'll fiddle around with it and see if I can get it to work
Dave