AnsweredAssumed Answered

ERP and it's structure

Question asked by robmertens on Sep 19, 2013
Latest reply on Sep 19, 2013 by Mike_Mitchell

Hello all,

 

i'm sure this is allready written down somewhere but i can't seem to find an answer to my Question.

 

When i build my Database i create Tables like Person, Adress, Phonenumber etc.

I choose to make these seperate tables because a person never changes but he might for instance move to another city or get a new or multiple phonenumber(s).

So i connected the three tables by a key.

Because of dataseperation (which i'm trying to accomplish) i want to be able too show the data from a person including his adress and phonenumber(s) from another master file (and thus i have to create a TO from the File/table Person) but....do i need to do the same for the tables adress and phonenumber with their respective relations or is the connection between the three in the original file enough to "look through the relations"?

 

Maybe it's basic knowledge but then again, i love getting new advices to make me rethink the things i allready think i know!

Outcomes