Okay, well, I think I've set up the module to work as well as it can...
So, now that I have run this "make table" query creating an "owner class" table that has 3 fields: 1) APN (which in the "owner class" table became Exp 1), 2) Owner1 name, 3) Ownerclass (i.e. GOVT, Non-buisness/ind, etc). I need to run another query that will combine the fields of "owner class" to the original table "Humboldt_Join_noURB" which contains other fields I need (i.e. address,x & y-coordinates, etc).
So, "owner class" table (after the make table query is run) shows having 37,153 records...which sounds right because there was exactly 37,153 records in the "Humboldt_Join_noURB" table.
But, watch this...
So, I go into relationships...and create a one-to-one relationship between between the "Exp 1" field (in "owner class") and the "APN" field (in "Humboldt_Join_noURB")....then I query using the SQL:
and...instead of 37,153 records...I get 38,151 records....SELECT Humboldt_OwnerClass.*, Humboldt_join_noURB.*
FROM Humboldt_OwnerClass INNER JOIN Humboldt_join_noURB ON Humboldt_OwnerClass.Expr1 = Humboldt_join_noURB.Humboldt_firethreat_APN;
Two tables joined with precisely 37,153 records should return 37,153...but it doesn't...
What did I do wrong??