Hi - before I start asking how to do things, first I would like to ask if this database is setup in such a way that would even allow it to be worked with.
I have tables that are linked from a master database so I cannot change how they are setup. A sample is attached. Please note how the Main table appears normal (with one ID number per row) and the other Phone Number table has the ID numbers on multiple rows with various phone numbers.
I am trying to make a query where everything is NORMAL (meaning one ID number per row and all the information on that one row). Everything I try is creating a mess. It creates multiple rows row each ID number OR for those that dont have a phone number it doesn't show them at all. This is a mess! Are databases even supposed to be made like the Master it is feeding from? Please see sample attached.