Always put your code within code tags (# on forum toolbar) because a) it's always easier to read b)it stops the forum from inserting spaces at the 50 character points and c)it often helps with spotting issues if you copy/paste and don't type here.
If your code really contains those special quotes it could be the problem - “1” Also could be that 1 is a number and you're treating it as text with those quotes. Moke123 eliminated them, probably assuming ID was a number but it may not be.
I don't see the need for a junction table here. Wouldn't this work?
Ignore the dots - I forgot to put table names in the first row.
tblPerson . . . . . . . . tblAddresses
PersonID |
Fname |
|
AddressID |
PersonIDfk |
Address |
1 |
Joe |
|
1 |
1 |
12 Main St. |
2 |
Sam |
|
2 |
1 |
25 John St |
3 |
Mary |
|
3 |
2 |
5 Maple Ave |
|
|
|
4 |
3 |
55 Warren Ave |
The more we hear silence, the more we begin to think about our value in this universe.
Paraphrase of Professor Brian Cox.