Recent content by SCDev

@The_Doc_Man Your tips helped! thanks alot appreciate it. Once I consolidated the county, zip, and city with a unique constraint, I redid the queries to select the 1 table instead of 3. worked perfectly and so much less code.

It felt overkill. Having one client could have a fk to the <city, county, zip> table on the primary id of said table, then referencing the <city, county, zip> table already has the relationships, and i can put any constraints needed on that table. after thinking about it from your point of view...

Most likely. Lookup fields blew my mind when I first saw them in a table. Ah. I thought about that before but DBA mind said "thats not how you normalise a database" but Access is different. I see why you're the Master level jedi. I do have a event procedure for "not in list", which runs the...

I can run the query alone and it works

oh. That is exactly the case. the client table has a fk to the zip table, which has a fk to a zip_residence table, and that zip_residence table has a fk from the residence table. So thanks for that info so how would I constraint cities to counties if I dont have a table for the relationships? I...

the combobox is a drop down that is supposed to show all the current client codes And allow for new ones to be entered. the value is a the client code from the client table SELECT TblClient.ClientID, TblClient.ClientCode, TblClient.CreateDate, tblEthnicity.Ethnicity, tblResidence.Residence...

Trying to insert a new record into a dynaset from a query SELECT TblClient.[ClientID], TblClient.CreateBy, TblClient.CreateDate, tblZip.City, tblResidence.Residence, tblEthnicity.Ethnicity, TblClient.ClientCode, TblClient.ModDate, TblClient.ModBy,TblClient.Language_Primary, FROM (tblZip INNER...

About Me: Developer for local government, mostly for C++, Java, SQL, python, and now Access/VBA, among others Skill level: Newish to intermediate. 4/10 in vba, 2/10 in access Country: California, Usa Hobbies: Sports, gym, traveling, dad life