Hello,
So, i have two tables. Let's name the first one tbl_seaports it contains 2 columns POL and POD (port of loading and port of delivery). Basically it's two column list of from and to sea ports. Second table is the name and UN code of the sea port. I cannot figure out how to create a relationship and create the last table below showing POL POD and their relative codes (see last table)
Any ideas will be very helpful.
Here is the link for the tables: https://onedrive.live.com/redir?page=view&resid=3978FACCB9D92839!4902&authkey=!AJoItlp7zBd8PWk
tbl_seaports
<tbody>
</tbody>
<tbody>
</tbody>
tbl_LocationCode
<tbody>
</tbody>
RESULT I AM LOOKING FOR :
tbl_seaports
<tbody>
</tbody>
So, i have two tables. Let's name the first one tbl_seaports it contains 2 columns POL and POD (port of loading and port of delivery). Basically it's two column list of from and to sea ports. Second table is the name and UN code of the sea port. I cannot figure out how to create a relationship and create the last table below showing POL POD and their relative codes (see last table)
Any ideas will be very helpful.
Here is the link for the tables: https://onedrive.live.com/redir?page=view&resid=3978FACCB9D92839!4902&authkey=!AJoItlp7zBd8PWk
tbl_seaports
POL | POD |
<tbody>
</tbody>
Bremerhaven | Savannah |
Bremerhaven | Seattle |
Busan | Houston |
Busan | Los Angeles |
Busan | Oakland |
Busan | Seattle |
<tbody>
</tbody>
tbl_LocationCode
Port Name | Port Code |
Bremerhaven | DEBRV |
Seattle | USSEA |
Houston | USHOU |
Los Angeles | USLAX |
Oakland | USOAK |
Busan | KRPUS |
<tbody>
</tbody>
RESULT I AM LOOKING FOR :
tbl_seaports
POL | POD | POL Port Code | POD Port Code |
Bremerhaven | Savannah | DEBRV | USSSA |
Bremerhaven | Seattle | DEBRV | USSEA |
Busan | Houston | KRPUS | USHOU |
Busan | Los Angeles | KRPUS | USLAX |
Busan | Oakland | KRPUS | USOAK |
Busan | Seattle | KRPUS | USSEA |
<tbody>
</tbody>