Corrupt Queries

[Matt020]

Help!

I dont know if this is a virus causing this. I have a brand new database with two unrelated tables. One table has names, the second address. I run a select query using just the name field from the names table, and I get a list of all my names as expected. When I use the show tables button to display address table, with just the same name field being entered as before and with no relationships created, I run the query again and all my name records have duplicated! Just by simply showing an extra table in the query is causing this. Disturbingly - the problem has spread to all my other databases's. Can anyone help! Thanks

 

[stopher]

If you have two table in you query then normally you need to relate them by joining a key field in one with the key field in the other. This will appear as a line in between the tables joining the key fields.

If you don't create a relationship then you will create what is called a cartesian product. This is every combination of the first table matched with every combination of the second table.

hth
Chris