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