Problem to make a new database

[niala]

I am a new user of Acces and this is my question.
I make a table with ( Name. first Name, type, civic adress and postal adress.)


There is 3 possibles choice in type: Permanent, non-permanent and season place.
With permanent the civic adress and the postal adress is the same.
Whith non-permanent and season place, the civic adress and the postal adress are different.
How can I make a good database structure with no duplicate data.
Thank you

[ranman256]

you cannot.
people can duplicate.
addresses can duplicate.
Its the bane of database managers everywhere.

If a person can have multiple addresses, then you will need a tAddr table to hold a persons many different places.
A 1 to many relation to the person

PersonID (long)
AddrID (autonum)
AddrType {perm,nonPerm,Season}
Addr
City
StateProv
PostalCode
Country