Database Table Setup and Pulling Info from Different Tables

Paul Gill

So I think I need a new Database table, but a lot of the entries already exist in other tables.  So for example, 8 of the 10 entries might exist elsewhere in other tables, so I want to populate this new database table with that information, such as Name, location, profile pic, etc.

This table will be used for a specific emergency function with added fields for that emergency; which is why I want it as a seperate table, but I'm unsure as to the best way to populate the new table with 'links' from other tables.

I realise that I'm probably missing the obvious!