jazzyt2u
05-02-2011, 03:32 PM
I'm new to coding for Access:
I have two tables that have property IDs. I have a third table that will input data from Table1 where the ID matches in Table2 AND where Property is in California in Table2. The problem is that in Table2 more than one person can live at the property therefore the property can be in there more than once. There is a different field that let's us know the difference and isn't needed now. When I join the two tables into the third I puts in duplicates based on Table2's property ids being in there twice. I really just want to verify not really join them. Is there something else i could use aside from join????
I have two tables that have property IDs. I have a third table that will input data from Table1 where the ID matches in Table2 AND where Property is in California in Table2. The problem is that in Table2 more than one person can live at the property therefore the property can be in there more than once. There is a different field that let's us know the difference and isn't needed now. When I join the two tables into the third I puts in duplicates based on Table2's property ids being in there twice. I really just want to verify not really join them. Is there something else i could use aside from join????