On 8/25/06, Richard Dillman [EMAIL PROTECTED] wrote:
YEP I just found a Training Coordinator that is also the County Director,
Child welfare Specialist and County Sherif!! And now some of the people
im
listing dont even work for the state, yep some of the training
Coordinators
are
Test page is up and working great .
As this is an info window for the data entry person. the Div updates onblur
so just tab or click out of the text box for your info.
http://www.webintegrity.us/zipcode/
Thanks for all the help guys!
--
--
Richard Dillman
[EMAIL PROTECTED]
(317) 916-8341
I
I usually use this Javascript but im not sure how effective it is...
script language=JavaScript type=text/javascript
!--
var contact = Indiana Adoption Program
var email = adoption
var emailHost = iquest.net
document.write(a href= + mail + to: + email + @ + emailHost+ +
contact + /a + .)
//--
On 8/26/06, Richard Dillman [EMAIL PROTECTED] wrote:
I usually use this Javascript but im not sure how effective it is...
The thing I like about webforms is that the address never goes
out. 'Keeps those addys private. Unless the address really
needs to be public... in which case, expect
Suggestion:
tblCountry
- countryID
tblStateProvince
- stateProvinceID
- countryID
tblCountyDistrict
- countyDistrictID
- stateprovinceID
tblZip
- zipID
- stateProvinceID
This is to maintain your lookup data. For the position:
tblPosition
- positionID
tblPositionZip
- zipID
- positionID
All the contacts will be inside Indiana, USA so lets say Marion County will
be split evenly between to people by a list of zipcodes where the zipcode
range is in Indiana so 46001 - 48000
but sence they are in Marion County the list is 46107 - 46298
I definately see where a cCounty Coordinator
Then it seems that you would just need the state, county and zip
relationship to manage adding of zip codes and then associate the zip codes
to a coordinator via the bridge table.
tblState
- stateID
tblCounty
- countyID
- stateID
tblZip
- zipID
- countyID
Then associate it to a coordinator.
On 8/25/06, Richard Dillman [EMAIL PROTECTED] wrote:
...
I definately see where a cCounty Coordinator will be county wide but a
Training Coordinator could be at the city level so based on zipcode but
not
in every county.
Man, I love databases.
Really you want to try to nail down this
Oh God, I totally agree on these,,, this dang project has had so many
acceptions to the rules and acceptions to their own exceptions.
YEP I just found a Training Coordinator that is also the County Director,
Child welfare Specialist and County Sherif!! And now some of the people im
listing
Maybe you could go with a join on persons to countries and a join on persons
to zip:
Contact_zip_jn
-contact_id,
-zip_id
contact_country_jn
-contact_id
-country_id
That way, you can categorize them in both ways with out having them to
overlap. Depends on how complicated you queries need
10 matches
Mail list logo