2

I have a table which has VesselPositions for every insured ship. Everyday new data is added for the vessel. In that Table I have a column named: IMO, Longitutude, Latitude, VesselPositionDate.

I also have another table, InsuranceData: It has IMO, ValidstartDate, ValidEndDate, PolicyValue.

I cant create a relationship between them because of the Many-to-Many issue.

On the Page im going to have: a slicer, where the user pick the VesselPositionDate. Below the slicer I will have Longitude and latitude in arcgismap. WHere all the vessels are ploted. So for everything is great. Below the table i want to have a table with insurance data from the table InsuranceData but i also want to show the longitude and latidude for that specific IMO ship on that date.

How would you set this up, simple doing a bridge table doesnt solve it. I can click a ship on the map, it filters the table below. But the Longitude and Latitude doesnt show correctly.

Improve this question
Related questions
0
Problem relationship many to many on Laravel
5
Power pivot many to many relationship between two tables
1
Highlighting with slicer Power BI
Load 6 more related questions Show fewer related questions

0

Reset to default

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.