PersonTest - Copy.zip
HI all,
I ran into a problem with my AddressFrm and don't know how to resolve it. I believe I need an Insert Into statement but not sure?
IN an attempt not to save duplicate files in tables, I made some changes to how to store the CSZ stuff, such as city, state, zip, and county to just saving the CSZID but ran into an issue.
So, when I go into my AddressFrm, and I update the City, Note: some cities have mutipul names for same zipcode and they are set by a checkbox called primary and is set by a class module. Once I enter a zipcode it auto populates the City, State and County. Example, if I enter 51334 Estherville, IA Emmett comes up. Well, 51334 has an additional city called Gruver, and if I select from combo, gruver, then it wont let me change back. So that is problem one. I assume that is due to problem 2 maybe? I need to update my AddressTbl with the CSZID depending on the selection of the City so it puts the correct ID in for the CSZID into that table. I am not sure just how to create such an update or even if that is what I actually need. The zipcode comes from the ZipCodeTable, I tried using the CSZTbl but that gave me a dropdown with mutipul zips of the same number. I don't think this is real complicated but neverless, I have been working on it all day today and no success in figuring it out. Please help....
I have attached a mock up db and had to remove a lot of zipcodes and CSZ,s from the tables to get it small enough to upload so zip codes are limited.
Thanks
Dave