RobertIngles
Technical User
Hi all;
Created a simple query from two tables.
In trying to normalize the data I created two tables:
One table has 17944 records - created by someone else with 12 fields.
From that table I created another table with 17,944 records using only 3 of the 12 fields from the original table.
When I create a query with a 1 to 1, show all matching records, I should get 17,944 matches. Instead I am getting 581,790 records returned. My join is between field UserName and UserName, text field set at 255 characters.
Not sure what the heck I had done so I went back to the original working DB, created a new DB with the two tables and got the same result.
Any suggestions or explanations would be appreciated!
Created a simple query from two tables.
In trying to normalize the data I created two tables:
One table has 17944 records - created by someone else with 12 fields.
From that table I created another table with 17,944 records using only 3 of the 12 fields from the original table.
When I create a query with a 1 to 1, show all matching records, I should get 17,944 matches. Instead I am getting 581,790 records returned. My join is between field UserName and UserName, text field set at 255 characters.
Not sure what the heck I had done so I went back to the original working DB, created a new DB with the two tables and got the same result.
Any suggestions or explanations would be appreciated!
