0v3rl0rd
New member
- Joined
- Mar 8, 2015
- Messages
- 4
- Reaction score
- 0
- Points
- 0
- Excel Version(s)
- Pro Plus 2019
Hi
I need some help. Let's say I have a list of PEOPLE that traveled to some LOCATIONS. I've got a table in Excel - it's structured like this picture:
I want to transfer this to my database, but before I do that I need to create a "many-to-many" table. How should I do that?
I also created two tables:
PEOPLE >> with attributes: ID and PERSON_NAME
LOCATIONS >> with attributes: ID and LOCATION_NAME
The ID's are unique for each entry.
I need to create a third table called (e.g.) "people_locations" where I'll put the ID of the person in the first column and the ID of the location on the second column.
So for example, in this third table (which would actually represent a many-to-many relationship) the entries (for the above picture) should look something like this:
Any ideas how to do this?
I need some help. Let's say I have a list of PEOPLE that traveled to some LOCATIONS. I've got a table in Excel - it's structured like this picture:
I want to transfer this to my database, but before I do that I need to create a "many-to-many" table. How should I do that?
I also created two tables:
PEOPLE >> with attributes: ID and PERSON_NAME
LOCATIONS >> with attributes: ID and LOCATION_NAME
The ID's are unique for each entry.
I need to create a third table called (e.g.) "people_locations" where I'll put the ID of the person in the first column and the ID of the location on the second column.
So for example, in this third table (which would actually represent a many-to-many relationship) the entries (for the above picture) should look something like this:
Any ideas how to do this?